date('Y-m-d') is how MySQL likes to see DateTime types represented.
$today = date('Y-m-d');
$query = 'SELECT * FROM tblEvents ';
$query .= "WHERE dtmEventDate >= $today ";
$query .= 'ORDER BY dtmEventDate DESC';
$result = mysql_query($query);
...etc...
Hope that helps.
-Mike
At 10:26 AM 7/31/
Hi,
I want to check the date of numerous records in many DB tables, I have tried
using the
date (Ymd); function but it doesn't appear to work, not sure whats going
wrong.
I set a variable based on this function and use this variable within the
select statement!
Anyone know whats happening or if
