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@xxxxxxxxx ////
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
