how to get selected data form data base

[phphelp]

hi
i want to know that if i have a table with fname,sname,age,sex and now i have a html page on it options to search from database any of these fields from check boxes means multiple also can be selected e.g i select fname and sname only from form.now how can i get data from database,what will be query,becoz thier will be a lot of choices for users to search.
thanks
its urgent plz

[spikeZ]

in your form you would have checkboxes for each item, named as fname etc.

on your php page (NOT HTML), you would have.

$query = "select * from table where 1=1 ";
if(isset($_POST['fname'])) {
$query .= "and fname = '". $_POST['fname'] . "'";
}
if(isset($_POST['sname'])) {
$query .= "and sname = '". $_POST['sname'] . "'";
}
$query_run = mysql_query($query); 

Something like that!

SpikeZ