You are here: Re: Query Question « PHP SQL « IT news, forums, messages
Re: Query Question

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

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация