Hey all,
I am currently making a site which users will be able to add songs to their playlist, however, I'm having problem getting mysql info and looping it correctly.
When I loop it, playlist shows double listings, instead of 1 result, I get 2 results that are same. Here's the full php code:

PHP Code:

<?php

//Removed

?>

What I am trying to do is, get the song ids from users' playlist and then for each id that is found, get the song info from a different table then add to playlist file which is needed for flash player.

FIXED!

Not saying this is the problem, but you *should* put the song info into the same table as the ids. It might not seem like the problem, but if you work with multiple tables odd things can occur.

-Brian

All mp3 info is together in one table. I used a separate table to keep track of songs added to user playlists. For example, when I add a song, it is added to playlists table with my session id and the song id. From there, I'm trying to get all the songs added by me, which will give me the id of the songs, and from those ids, i need to pull song info for each song.

Thanks