Calender dates

[Cuban]

im not sure if this is possible, but what i want to do is have a calender with 3 fields: date, activity and equipment.
on the main page to the site i want a section that will take todays date and find the next date in the calender and disply all the feilds for that date.
i have no idea how to do this bit???
can anyone help??

[volleytotal_ch]

table structure for "events"

id | date | activity | equipment

where id is "auto-increment"

// select next event (just one):
$query = "SELECT * FROM events WHERE date >= CURRENT_DATE LIMIT 0,1";
$res = mysql_query($query,$db_conn) or die("Can't connect to DB!");
if(mysql_num_rows($res)==1)
{
  // Found event: output (or do something else)
  $event = mysql_fetch_assoc($res);
  echo "Next event: ".$event["date"].", ".$event["activity"].", ".$event["equipment"]."!<br>";
}

hth

[Cuban]

thanks that does help a lot. but im still having a few problems with it. it doesnt seem to display any results?
what date format is the current_date in?
thanks