March 22nd, 2000, 08:56 PM
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?
March 23rd, 2000, 08:45 AM
>select event_title, event_date
>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