[PHP] Re: need to find a way to remove similar keys

2002-08-25 Thread electroteque

sorry i found array_unique , so then how could i append the keys out of
mysql bak into one array ?

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




[PHP] Re: need to find a way to remove similar keys

2002-08-25 Thread electroteque

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