[PHP-WIN] Get rows over certain data

[PHPWIN]

Hi 
   Anyone knows how to retrieve rows over a certain date in MySql if the rows all have 
a datetime field, of type timestamp .
Like to get the rows modified in the last week or 3 days or just today?

Thanks
Xon