 |
 |
Find a programming school near you
php3-list | 199901
Date: 01/22/99
- Next message: Colin Viebrock: "Re: [PHP3] Searching .PDF, .DOC files"
- Previous message: Rich Clingman: "Re: [PHP3] mail() & multiple recipients with NT"
- In reply to: Mark: "Re: [PHP3] querying multiple fields of database"
- Next in thread: Richard Lynch: "Re: [PHP3] querying multiple fields of database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
> Hitting the search button would return one result, not ten duplicates or
> whatever.
>
> Is this good enough?
> mysql> select * from OBJECTS where artist like '%pascin%' or material like
> '%paint%' or title like '%girl%'
Make it: "SELECT DISTINCT * from OBJECTS ..." if you don't want duplictes.
- colin
-- PHP 3 Mailing List http://www.php.net/ To unsubscribe send an empty message to php3-unsubscribe <email protected> To subscribe to the digest list: php3-digest-subscribe <email protected> For help: php3-help <email protected> Archive: http://www.php.net/mailsearch.php3 List administrator: zeev-list-admin <email protected>
- Next message: Colin Viebrock: "Re: [PHP3] Searching .PDF, .DOC files"
- Previous message: Rich Clingman: "Re: [PHP3] mail() & multiple recipients with NT"
- In reply to: Mark: "Re: [PHP3] querying multiple fields of database"
- Next in thread: Richard Lynch: "Re: [PHP3] querying multiple fields of database"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
