[SOLVED] Convert timestamp back to numeric representation

[jaxdevil]

$result=mysql_query("select * from payments_received order by invoice_number WHERE `date`>='2008-09-25 11:10:31' asc");

 

That is my query string now, obviously it doesn't work. I need to find out how I can convert the timestamp, formatted as above, into the unix style numerical values only (ex: 1222433088) . I need that so I can use the greater than less than in my query to locate data based on the date and time of entry into database.

 

Thanks in advance,

SK

[efficacious]

This might help you.

 

http://us.php.net/manual/en/function.strtotime.php