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 //
> + _
> emiliano.boragina@gmail.com ////
> 15 40 58 60 02 //////////////////////////
> + _
>
--
Jas
"Tomorrow isn't promised so we live for today"
|