PHP3, MySQL - AutoGenerated Page by date

I'm working on a webpage that i would like to have autogenerated content, using PHP3 and MySQL. Basically, I would like it to pull information out of the database and post the date and title for the event, based on the current date on the server.
Does anyone know of a place where I could see this done? or have any sample code i could look at?
thanks,
dave.

>select event_title, event_date
>FROM event_table
>WHERE to_days(now()) - to_days(event_date)=0

// [ORDER BY event_title|event_date] or whatever....

Assuming the event_date column is a valid date, time or timestamp datatype