[PHP] Date -1

[David Smith]

I am trying to show the records created from the previous day. How can I make it show 
the date before today? My date field is like 2001-01-24 16:13:51. Below shows the 
current day...


$FileDate = date ("Y-m-d");

$connection = mysql_connect ("localhost", "*****", "******");
if ($connection == false){
  echo mysql_errno().": ".mysql_error()."<BR>";
  exit;
}  

$query = "select * from warbirds_db WHERE FileDate LIKE '%$FileDate%' ORDER BY FileID 
DESC";
$result = mysql_db_query ("combatfs", $query);