[prev in list] [next in list] [prev in thread] [next in thread] 

List:       php-general
Subject:    [PHP] Re: need to find a way to remove similar keys
From:       210.49.31.16
Date:       2002-08-25 11:26:31
[Download RAW message or body]

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" <daniel@electroteque.org> wrote in message
news:20020825105249.93073.qmail@pb1.pair.com...
> 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

[prev in list] [next in list] [prev in thread] [next in thread]