a better way of expressing this.....

i have the following block of php code to read and extract all databse entries marked with todays date on them:


$thedate = date("Ymd");
$query = "SELECT *,DATE_FORMAT(date,'%Y%m%d') AS fdate, FROM stats";
if ($mysql_result = mysql_query($query, $linkdb)) {
if (ExecuteQuery($linkdb, $result, $query)) {
while ($row = NextRow($result)) {
if ($row['fdate'] == $thedate) {
#print out the record etc.
}
}
}
}


i'm looking for a way i can do this in one go in the SQL query string, without having to go through all of them.
the field 'date' is a 14digit timestamp.

Why don't you just select the records with todays date instead of pulling all the records?

$query = "SELECT * FROM stats WHERE datefield = '$todaysDate'";

ah, yes.
I WOULD do that but I cant.

The date field is defined as (say) 20021109hhmmss
and the only SELECT statement I can fire at it is:

SELECT * FROM stats WHERE date = "20021109"
i can't define the time, and that essentially is where the problem lies as I want to select every record for todays date.

Ok so then use the LIKE command:

$query = "SELECT * FROM stats WHERE datefield LIKE '$todaysDate'%";

Or

SELECT * FROM stats WHERE TO_DAYS(date) = TO_DAYS("20021109")

if you have to compare against a certain timestamp; if you need to get the rows of today's date, then use

SELECT * FROM stats WHERE TO_DAYS(date) = TO_DAYS(CURDATE())