Search Engine

[elemelas]

Hi guys,

I'm building search engine which has many fields:

<input type="checkbox" name="who1" value="1" />Michael
<input type="checkbox" name="who2" value="1" />John
<input type="checkbox" name="who3" value="1" />Andrew
<input type="checkbox" name="who4" value="1" />Sean
<input type="checkbox" name="who5" value="1" />Alex
<input type="checkbox" name="who6" value="1" />Martin

<select name="sex">
                            <option>Male</option>
                            <option>Female</option>
</select>

<input type="text" name="age_min" class="text" />
<input type="text" name="age_max" class="text" />
etc...........

Now I'would like to display search results, and I'm bit stuck. What is the best way to write the syntax for mysql using some kind of loop+array, I was trying to go step by step like:

if(isset($_POST['who1'])) { 
$search = "person='Michael"; }
if(isset($_POST['who2'])) { 
$search = "person='John'"; }
..................

if($_POST['sex']=="Male") { 
$search = " AND sex='Male"; }
if($_POST['sex']=="Female") { 
$search = " AND sex='Female"; }


$query2 = mysql_query("SELECT * FROM profil WHERE $szukaj");

But that only allows me to have one search string per section plus it's a long code. I know I can use

$search .= " OR person='John'"

But that won't work if person1 isn't selected. How can I use loop + maybe array to shorten the code and make it work properly ... ?

Thanks for any advices

[halojoy]

<input type="checkbox" name="who[]" value="0" />Michael
<input type="checkbox" name="who[]" value="1" />John
<input type="checkbox" name="who[]" value="2" />Andrew
<input type="checkbox" name="who[]" value="3" />Sean
<input type="checkbox" name="who[]" value="4" />Alex
<input type="checkbox" name="who[]" value="5" />Martin

Will be an array $who with only checked result
Each person have different value number 0-1- ......

Try this:

<?php

if(isset($_POST['who'])){

// $persons[0]..[1]..[2]..[3]..[4]..[5]
$persons = array('Michael','John','Andrew','Sean','Alex','Martin');

$who = $_POST['who'];//get the 'who' array

$search_persons = array();
foreach($who as $value){
		$search_persons[] = $persons[$value]; //add name
}		
//display result array
echo '<pre>';
print_r($search_persons);//szukaj persons

print_r($_POST); //show post
exit();
}// STOP

?>
<form method="post">
<input type="checkbox" name="who[]" value="0" />Michael
<input type="checkbox" name="who[]" value="1" />John
<input type="checkbox" name="who[]" value="2" />Andrew
<input type="checkbox" name="who[]" value="3" />Sean
<input type="checkbox" name="who[]" value="4" />Alex
<input type="checkbox" name="who[]" value="5" />Martin
<br />
<input type="submit" />
</form>

[elemelas]

Right, but how to incorporate the result it into the syntax ?

$query = mysql_query("SELECT * FROM profil WHERE $search_persons");

it doesn't have to be done with variable, anything that will work .. remembering that i have few more inputs, and not all of them have to be filled ..