[RESOLVED] Compare Dates

[lintz]

I'm trying to select only records in my database (mySQL) after a certain date but when I use the strtotime() function it returns the "time" in mm/dd/yyyy format where as I am working in dd/mm/yyyy format. How do I overcome this?

//If you test the below code the $mytime will be greater then time() which is can't be??
$mytime = strtotime("09/03/2006");
echo "MyTime = $mytime and " . time() ."<br>"; 

[AIS4U]

lintz:

I think you might want to use the Date_Format function?

You can read about it in the manual at:

http://dev.mysql.com/doc/mysql/searc...Fen%2F&lang=en