Home  |  Linux  | Mysql  | PHP  | XML
From:Jason Gerfen Date:Mon Jun 29 15:27:33 2009
Subject:Re: multiple finder
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"
Navigate in group php.db at sever news.php.net
Previous Next


Your recent visits
Re: [PHP-INSTALL] Re: PHP 5.3.0 as a module on windows
Re: [PHP-DB] mysqli error
PHP- Mysql problem
Unable to run programs in php


  
© No Copyright
You are free to use Anything
Site Maintained by Zareef Ahmed
Powered By PHP Consultants