help with extracting dates for a calendar

[abbey]

hello everyone i'm building a calendar for people to input their own events and what not. and the way i'm storing the dates for their event is in a timestamp.

what i want to do is pull the events according to the current date or the event that is closes to the current date and just start listing the rest of the events thereafter.

So today is january 15 and i want to pull all events that are on january 15 or any event that is close to the 15, whether it is january 16,17,18 etc.. as the starting point. Once i can figure out how to pull that one event i can just loop through my database.

anyone happen to have any ideas on how to do this?

thanks again mates.

[ultraslacker]

For mysql -

SELECT * FROM foo WHERE datebar >= CURDATE();