[RESOLVED] how to select last 7 days from db using dates

[VisionsOfCody]

Hi

this is probably very simple but i can't get it

I have a load of dates in my 'orders' table in this format 2006-10-25 and i need to be able write a query that would select all orders in the last 7 days - in fat it can be any number of days but that's a variable from a select menu

what i can't work out is how to write the query :

SELECT * FROM orders WHERE ord_date ..(is between x days ago and today) ???!!

can anyone help ?

thanks

[cahva]

SELECT * FROM orders WHERE TO_DAYS(NOW())-TO_DAYS(ord_date) <=7

[VisionsOfCody]

I've never seen that type of sql query before - but I tested it and it works perfectly

thanks!