event listing with PHP, MySQL, Date

need help

[bbitgen]

Hi,
I am going to try to tell you what i need:

The website i am working on, has an admin panel that info is entered to the database, and the visible pages take the info from the database (naturally :))

I need to build something like an event calendar, such:

1) The admin will be able to insert the header of the event, the description and the date and time of the event. (Not the date of the current day)

2) The events will be listed on one page

All is ok for now.

3) at the main page, I need the php to check the current date, and display the day's event.

First, I couldn't find a way to insert a future date into the MySQL, in fact this is my greatest problem i think.
Second, of course, I can't retrive that info.

I am new to MySql and PHP, if anyone could help me out, I will be a lot thankfull.

ps: It seems it is a bit urgent, too.

[dreamcatcher]

You might want to check up on the PHP/MySQL date formats and how they are used:

MySQL
http://dev.mysql.com/doc/mysql/en/Date_and_time_type_overview.html [dev.mysql.com]

PHP
http://uk2.php.net/manual/en/function.date.php [uk2.php.net]

Hope that helps. :)