Posted by Kimmo Laine on 09/30/05 12:40

"cjo" <coverlandNOSPAM914@yahoo.com> wrote in message
news:iijpj1h7r956omvhktpkfapjoqa2h9j727@4ax.com...
> Used some of the code you posted and got it working - thank you. Is
> there a way to keep duplicates out in a query? If you had three
> entrys for 'spot', five for 'oscar' and so on, how would you keep the
> duplicates out of the query?
>
> Also something I discovered, for the life of me, I couldn't make the
> php query code run properly within an html TABLE document (even though
> the extension is .php)
>
> I have been using a table type html doc because it looks neater with
> the three pulldowns within it.
>
> thanks again for any help...


Use keyword DISTINCT for that. It reduces duplicates to a single entry.

--
Welcome to Usenet! Please leave tolerance, understanding
and intelligence at the door. They aren't welcome here.
antaatulla.sikanautaa@gmail.com.NOSPAM.invalid

[Back to original message]