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.