show records based on computer's date

[kappaluppa]

I am using php & mysql to manage an event calendar which creates a separate very detailed page of information about the event.

When a person clicks on an event listed in a table, rather than the ususal calendar style, you are taken to the full page description.

What I need help doing is setting up the table so that the old events "roll off" the table. I assume you would use the date function in conjunction with the user's computer clock/calendar.

What I am thinking is that I have to have the code check the computer's date, then based on that info not include certain records from the db.

Now my question: Does anyone know how to do that? ;o)

Thanks,
Kathy

Or, if you know of a better way to do it, I'm all for it!

[barand]

$today = date("Y-m-d");

$query = "select * from event_table where eventdate >= '$today' ";

hth