Re: Date question

use this 

SELECT * FROM fixtures WHERE Match_Date BETWEEN now() AND (now() -7)

Hey try this. This will surely work

SELECT * FROM fixtures WHERE Match_Date BETWEEN now() AND date_sub(now(), 
INTERVAL 7 DAY);

Thanks for all the reposnses but none of them seem to work for me.

Has anyone used these before with a MySql database and had anything similar
happen?

I doubt you tried my solution of calculating the date in your application logic.
 If this is failing then you probably did not implement the logic correctly.

Thanks for the help!