Creating Search Code ?

[Shalini Bhalla]

Hi ,

i am developing an application based on real estate agents.I need to put n no. of search criteria in that.
I want to know the best coding for creating search criteria with minimum efforts. I have some 10 to 15 fields on which i need to create search. do i have to write all queries or there is any other professional method which can help me in writing a single or less queries with different search criteria.

[perhapscwk]

suggestion as below.

each criteria need one more row as below

 
$sql = "select * from table where id=xxx";
 
if ($criteria1){
    $sql  .= " and criteria1 like \"%$criteria1%\"";
    }
.
.
.
 
if ($criteria15){
    $sql  .= " and criteria15 like \"%$criteria15%\"";
    }
 

[Shalini Bhalla]

till now i am doing this only , but i need to take care of n no. of criteria , anything in shortcut .

[perhapscwk]

use loop...

table field store as array
variable store as array.