query to filter out past dates

[Anon]

i have a mysql table that stores dates of events, and there are three columns that record the date. event_year, event_month, and event_day, respectivley, in a two-digit format. i don't have a problem sorting the query results chronologically, the trick is to skip events that have already past. the entries could be manually deleted, but i'm sure there's got to be a better way. here's my php file so far. oh, and by the way, the output is to a flash movie, if you were wondering.

<?
$host = "xxx.xx.xxx.xxx";
$user = "xxxxx";
$pass = "xxxxx";
$dbName = "xxxxx";
$tableName = "events";
$cYear = date(y);
$cMonth = date(m);
$cDay = date(d);
$link = mysql_connect ($host, $user, $pass);
$query = "SELECT * from $tableName ORDER BY event_year, event_month, event_day LIMIT 5";
$result = mysql_db_query($dbName, $query, $link);
$entry = 1;
while ($row = mysql_fetch_array($result)) {
$row[event_other] = nl2br($row[event_other]);
$events .= "&date0$entry=$row[event_month]/$row[event_day]/$row[event_year]&citystate0$entry=$row[event_city], $row[event_state]&venue0$entry=$row[event_venue]&contact0$entry=$row[event_contact]&other0$entry=$row[event_other]";
$entry = $entry + 1;
}
echo $events;
mysql_db_query($dbName, $query, $link);
mysql_close($link);
?>

initially i thought that i could just find the current year, month, and date and filter out < values, but obviously, if you think about it, that doesn't work. 01/01/03 comes after 09/09/02 but would be filtered out. i'm convinced the answer is obvious, but it's escaped me thusfar. i appologize if this has been answered before, i took a look but there's so much content to look through.

thanks.

[Anon]

compare year/month/day instead of month/day/year and you will be fine.

[kappaluppa]

I saw your request for information about filtering out past dates. sounds like you are doing what I am trying to do in creating a Calendar of Events. Can I have the url to the page where your list is displayed so I can see if you are doing what i want to do?

Thanks!
Kathy

[Anon]

Richard, thanks for the reply. using the query i was playing with the results are the same no matter the order. obviously AND is not the answer alone.
$query = "SELECT * from $tableName WHERE (event_year>=$cYear AND event_month>=$cMonth AND event_day>=$cDay) ORDER BY event_year, event_month, event_day LIMIT 5";

so let's say the current date is 02/08/12 and i have the following dates in my database, again, each part stored in different columns:
03/01/01
02/08/11

each would be filtered out because in the first date, though the year 03 is greater than 02 (current year), the month and day are less than therefore will be passed over. the second is also filtered out because it's the day before, which is fine. this method isn't acceptible for this task.

kathy, unfortunately this is all just early development stuff, the url is quite temporary. what i have, though, is essentially this:
02/08/12 - vancouver, bc - the commodore ballroom - [e-mail]

other bands appearing are so-and-so with the etceteras

02/09/01 - kingstore, on - aj's hangar - [e-mail]

other bands appearing are so-and-so with the etceteras

02/12/21 - toronto, on - the warehouse - [e-mail]
other bands appearing are so-and-so with the etceteras

and so on. the date is month/day/year and each bit of data is stored in a separate column so i can format things around easily.