help with calendar and date finding

[abbey]

i'm trying to make this simple calendar type of program to where the users will be able to submit new events and shows.

what i'm trying to do is figure out a way to where the script will:

--1. first figure out what the date is today
--2. then after the date is figured out it will take the events that fall on that date and all of the events within a week of that date.

i just dont know how to work out the dates of the current day and the ending date.

any help would be greatly appreciated.

thanks again.

[nemonoman]

Today is CURRENT_DATE

A Week from now is

DATE_ADD(CURRENT_DATE, INTERVAL 7 DAY)

You'd do something like:

SELECT *
FROM sometable
WHERE somecolumn
BETWEEN CURRENT_DATE
AND
DATE_ADD(CURRENT_DATE, INTERVAL 7 DAY)

http://theory.uwinnipeg.ca/MySQL/manual_Syntax.html