search question

if i have a form that allows users to select critera to search against... age, sex, location etc etc

is it possible to make it so that my query will ignore a field left blank?

a wildcard for example, or do i have to write multiple if else statements to amke my sql querey suit the situation?

Sure you can

All you need to do is go through the $_POST array (Assuming you are using post and not get). Then simply say something like this


if(!empty[var name])
{
include the var name and var value 

}

The trick is to explictly indicate that you only want to have only those vars that are not empty.

hth

WHERE ( s1 LIKE '%$s1%' OR s2 LIKE '%$s2%' OR s3 LIKE '%$s3%' OR s4 LIKE '%$s4%' OR s5 LIKE '%$s5%' ) AND s6 = '$s6'

ill have a look into the include tomorrow ... thanks... the LIKE method doesnt suit as i still want the search to be explicit :queasy:

Then use = instead of LIKE