Re: need to find a way to remove similar keys

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? > >