Greater than Query

[raouleduke]

I have this query that works, but does not give me all the records greater than the date, I printed the query, and it shows up in there, let me know if you have any thoughts.

$query = "UPDATE $catagory$subcatagory SET ACTIVE='1' WHERE LASTSERVDATE > ".$date."";   

  if($select_make =='1'){
  $query.=" AND MAKE IN ('".$MAKE."')"; 
  }
  if($select_model =='1'){
  $query.=" AND MODEL IN ('".$MODEL."')"; 
  }
  if($select_year =='1'){ 
  $query.=" AND YEAR IN ('".$YEAR."')"; 
  }
  if($select_city =='1'){ 
  $query.=" AND CITY IN ('".$CITY."')"; 
  }
  if($select_state =='1'){
  $query.=" AND STATE IN ('".$STATE."')"; 
  }
  if($select_zip =='1'){
  $query.=" AND ZIP IN ('".$ZIP."')";
  }

Here is the query:

UPDATE LUTHERSELLANDRECOMMEND SET ACTIVE='1' WHERE LASTSERVDATE > 2003-11-01 AND MAKE IN ('BUICK','CADILLAC','CHEVROLET')Thank you information updated!

[nemonoman]

you need to quote the date:

$query = "UPDATE $catagory$subcatagory SET ACTIVE='1' WHERE LASTSERVDATE > '$date' ";