is the date 'today'?

[tonyw]

hi, just looking for a way to find out if a date - timestamp(14) returned from mysql - is todays date?

As i want to do it a lot, wondered if there's a super quick n crafty way to do it?

thanks

tony 🙂

[superwormy]

PHPs date() function will tell you today's date...

date ("Y-m-d");

[[deleted]]

Try something like this:

<?
function isToday($timestamp) {

if (date ("m.d.y") == date("m.d.y", $timestamp)) {
    return TRUE;
}
return FALSE;
}

$timestamp = strtotime('October 22, 2002');

if (isToday($timestamp)) {
    echo "It matches!\n";
}
?>

[bretticus]

timestamp datatype form MySQL is not a UNIX timestamp and you cannot use it in it's default format with the PHP date function. You can however use the MySQL UNIX_TIMESTAMP() function to convert it as you query the database:

$query = "SELECT *,  UNIX_TIMESTAMP(timestamp_field) AS curdate FROM table";

[tonyw]

thanks very much everyone 🙂