Using MySQL to print out a Calendar!

[donald3]

Okay, I have a bit of a dilema... I have a table, I can print out events that happen in a calendar (the data is in this table) for that which is happening THIS DAY, or THIS MONTY (i.e. printing out everything in the table), but I am not sure of any methods of printing out events happening that week!

I don't know if I can use the $today = (d) (or whatever the code is, I can look it up), get the number of the day, and then
SELECT * WHERE event_Date = $today TO $today + 7 .... something to this effect is what I want! ,but I have a suspicion that it is not "legal" code.

Thanks,
Donald

[Bunkermaster]

first get today's week day number :
use [MAN]date/MAN to get from 0-sunday to 6-saturday
use [MAN]strftime/MAN to get 1 to 7 being monday to sunday

then use it to get your first week day (sunday or monday depending on your culture)then get last day and voila you have your week