Sorting Database

[raouleduke]

I am trying to allow users to select active records in the database, they will be allowed to refine their query if they want to, I am have trouble when they want to further their query. Here is what I got so far.

if($sort=='make'){
$MAKE = implode("','",$_POST['MAKE']);
$query = mysql_query("SELECT * FROM $catagory$subcatagory WHERE ACTIVE = '1'");
$check_num = mysql_num_rows($query);
if($check_num){
$query = "UPDATE $catagory$subcatagory SET ACTIVE='1' WHERE MAKE IN ('".$MAKE."') AND ACTIVE='1'";  

print $query."<br />"; 
$result = mysql_query($query) or die(mysql_error());
print "Thank you information updated!\n";
}else{
$query = "UPDATE $catagory$subcatagory SET ACTIVE='1' WHERE MAKE IN ('".$MAKE."')";  

print $query."<br />"; 
$result = mysql_query($query) or die(mysql_error());
print "Thank you information updated!\n";
}
print "<meta http-equiv=\"refresh\" content=\"1; URL=activedata.php?subcatagory=RECOMMEND\">";
}

Thanks in advance.

[freebie]

use code like this:

$query = "UPDATE $catagory$subcatagory SET ACTIVE='1' WHERE MAKE IN ('".$MAKE."') AND ACTIVE='1'";   

if($_POST['MySelectBox']!=""){
  $query.=" AND SomeColumn LIKE '%".$_POST['MySelectBox']."%'";
}

-- for checkboxes if it's not checked, it won't be POSTed, so make sure to use isset() for these to verify it exists else you'll get an error (as well as radios where none of the radios have been selected)