Show most recent entries

[Eiolon]

I want to the most recent entries in a table but I want to have a cutoff date of 2 weeks.  Entries that are more than 2 weeks old won't be listed.  All entries are stored with a mysql datetime column:

 

record_added datetime not null default '0000-00-00 00:00:00'

 

Any idea on how I could do this?  Thanks!

[DarkWater]

#SQL
SELECT * FROM your_table WHERE record_added > (DATE_SUB(NOW(), INTERVAL 14 DAYS)) LIMIT 20;