selecting only 7 days records from table

[phex]

guys

What is a mysql syntax for selecting all records enterd in the last 7 days from a table?

[Demaestro]

It depends. Are you storing the dates that a record is entered on?

If yes, in what data type? DATE, DATETIME, STRING?

[rocknbil]

^ ^ That would be important. :-) If it's a datetime (or timestamp) field, use now() instead of curdate(), but for date format, if you want to include today,

select * from table where datefield >= date_sub(curdate(), interval 6 day) and datefield <= curdate();

If you want the previous 7 days NOT including today,

select * from table where datefield >= date_sub(curdate(), interval 7 day) and datefield < curdate();

If it's varchar, you have a problem and it has to be done in your programming.

[phex]

Demaestro

Yes i am storing the dates and the field is time and its data type is timestamp.

[Demaestro]

This should be what you need then

select * from table where datefield >= date_sub(curdate(), interval 6 day) and datefield <= curdate();

[youngflower]

Sorry, I cannot solve your problem.

[phex]

thanks a lot guys for the code. The now() does it for me, i appreciate.