txt_Venuename
txt_Areacode
opt_Venuetype
opt_Agegroup
opt_Musictype
and the db columns are:
venuename
areacode
venuetype
agegroup
musictype
it should look like this:
Code:
Code: Select all
$sql = 'SELECT * FROM `some_db` WHERE ';
$flag=0;
if( $_REQUEST['text1'] ) {
$sql .= "field1 LIKE $_REQUEST[text1] ";
$flag+=1;
}
if( $_REQUEST['text2'] ) {
$sql .= ($flag >=1 )?"AND field2 LIKE $_REQUEST[text1] " : "field2 LIKE $_REQUEST[text1] ";
$flag+=1;
}
if( $_REQUEST['op1'] ) {
$sql .= ($flag >=1 )?"AND field3 LIKE $_REQUEST[op1] " : "field2 LIKE $_REQUEST[op1] ";
$flag+=1;
}
if( $_REQUEST['op2'] ) {
$sql .= ($flag >=1 )?"AND field4 LIKE $_REQUEST[op2] " : "field3 LIKE $_REQUEST[op2] " : "field2 LIKE $_REQUEST[op2] ";
$flag+=1;
}
if( $_REQUEST['op3'] ) {
$sql .= ($flag >=1 )?"AND field5 LIKE $_REQUEST[op3] " : "field4 LIKE $_REQUEST[op3] " : "field3 LIKE $_REQUEST[op3] " : "field2 LIKE $_REQUEST[op3] ";
$flag+=1;
}
//...........
$sql .=";";
//executenow what do i replace $flag with.......
and then this should give the user any combonation af search no matter what field they choose.......to narrow down their search....