Re: multiple finder

From: Date: Mon, 29 Jun 2009 15:27:33 +0000
Subject: Re: multiple finder
References: 1  Groups: php.db 
Request: Send a blank email to php-db+get-46253@lists.php.net to get a copy of this message
Emiliano Boragina wrote:
Hi, I must do e finder for properties... I know do a simple search but not a search like this with more one possibility, with all or some fields full... How do it? Thanks a lot
Example database table to search: TableName Field001 Field002 Field003 Example SQL to search fields with some or all of the fields matching: SELECT * FROM TableName WHERE Field001 LIKE 'string' OR Field002 LIKE 'string' OR Field003; For future reference the PHP website as well as the MySQL website have examples for any type of functionality you wish to locate. I would suggest researching a the 'select' command from the MySQL website: http://dev.mysql.com/doc/refman/5.0/en/select.html
--
+                                                    _
Emiliano Boragina // Diseño y Comunicación /////////////
+                                                    _
emiliano.boragina@gmail.com //// 15 40 58 60 02 //////////////////////////
+                                                    _
-- Jas "Tomorrow isn't promised so we live for today"

« previous php.db (#46253) next »