Date -1
| From: | David Smith | Date: | Thu, 25 Jan 2001 08:37:12 +0000 |
| Subject: | Date -1 | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-36583@lists.php.net to get a copy of this message | ||
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);