never mind SELECT DISTINCT u.user_name, u.email, p.userID FROM user u LEFT JOIN photos p on p.userID=u.user_id WHERE p.galleryID='$galleryID'
heh "Electroteque" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > hi i am trying to find a possible way to remove similar id keys and pass > back just each different one , for example i have a photo gallery each photo > has a userID key of who the photo was taken by i would like to grab all the > id for each photo and pass back just one result of the different people who > have taken the photos > > so i append them all like 1, 1, 1, 1, 2, 1, 2, 1, 3 and i just want to get > back 1, 2, 3 keys? > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php