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.borag...@gmail.com ////
  15 40 58 60 02 //////////////////////////
+                                                    _



--
Jas
"Tomorrow isn't promised so we live for today"

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to