[SOLVED] Date function help

[psychowolvesbane]

Okay I want to know how I can use the date function to query against records in a table, and to show only records that are 2 weeks old compared to todays date.

 

So the table record is set to date(Y-m-d), so how do I go about comparing it with the current date and finding any records older than 14 days old? I don't need to worry about the sql, just get it so there is a variable to compare against. 

[p2grace]

The easiest way is to use the query to do it.

 

$query = "SELECT * FROM `table` WHERE `date_field` >= DATE_SUB(NOW(), INTERVAL 14 DAY)";