Time questions again

[rulian]

Okay, i got my code down to two functions I have no idea how to write:

1 I need a function that will get a date stamp from a mysql table, if that date has not been reached yet, it will not allow access.

2 Also, I function that will get the date/time stamp from a mysql table, if the date has passed, it will not allow function.

problem is I still dont know how to compare or manipulate time in mysql. HELP!

[jordan]

To get a PHP-style Unix timestamp in MySQL use UNIX_TIMESTAMP(Column_name) .. where Column_name is the name of your datetime field in MySQL. Once you have this number, you can compare it in PHP using your regular comparison operators. For example, if you wanted to see if a date has passed, do the following:

$now = time();
$then = $row["datetime"] // this should be your MySQL column

if($now < $then) { print("The date has not passed."); }