rocknbil - 9:59 pm on May 5, 2011 (gmt 0)
Welcome aboard . . . you have a field with the data type of date or datetime . . .then
select * from table where datefield >= date_sub(curdate(), interval 7 day);
If you don't have a field with a date/timestamp, you should. :-) Create one.
Alter table tablename add datefield datetime not null default '0000-00-00 00:00:00';
Try to avoid naming fields the same name as reserved words . . . date, datetime, insert, etc.