Calendar of sorts - Please Help

[digitalgravy]

I have a mysql database setup with information on upcomming events for an organization I am a member of. I know how to connect to the database, and display info from it using php. What Im trying to do is have a section on the site where it will show the next event for different categories.
How can I specify in my php code to display the next event in a category in relation to the current date?

Please help
-Jacob

[Joan Garnet]

An example contrasting two dates:

Code: Select all

echo ( strtotime ("10 September 2003") - strtotime ("now") );

Implement it in your script.
Bye!

[digitalgravy]

Thanks, although I found another way that works.
It is: now()

[Joan Garnet]

There should be a thousand ways
That one sounds good anyway ;)

bye!