Date range from a single Date

[d0nny]

Hi

I have a football fixtures table with a date of the fixture stored with the fixture.
I want to display this fixture on my website for (say) 3 days before the actual fixture date and (say) 3 days after the actual fixture date.
Is this possible from within a single query?
I think this might have something to do with the DATEADD/DATESUB functions, but I can't work out how to use these in the WHERE clause of my query.

Any help appreciated.

 

[TonyGroves]

How about something like:
[tt]
WHERE
fixdate
BETWEEN CURDATE() - INTERVAL 3 DAY
AND CURDATE() + INTERVAL 3 DAY
[/tt]

 

[d0nny]

Thanks.
I'll give it a try and let you know.

 

[d0nny]

Worked a treat
Thanks a lot ...