[RESOLVED] Date confusion

[Double_M]

Hey all,
I got another date question here.
I have a date sent to a page, which is 02/02/2007 and i need to find any records in a database that are 90 days older than this date.

Id rather make a date that is 90 days older than that date
and then do a "SELECT * FROM blabla WHERE RECORDDATE<=$newdate";

A usual question but i cant quite get it.

Any help much appreciated.

[devinemke]

$date = '2007-02-02';
$sql = "SELECT * FROM table WHERE date_col <= DATE_SUB('$date', INTERVAL 90 DAY)";

[Double_M]

That worked great thanks 😃.

Another question tho 🙂, how would i go about matching a date from the database? e.g.

$date = '2006-02-02';
$sql = "SELECT * FROM table WHERE date_col=<$date";

Is there something similar i have to do to the statement like the previous question?

Thanks again.