PHP / MySQL: Sorting through Data

[donald3]

Hello!

Unfortunately I'm struggling a bit with a statement so that I can take information from a calendar of events and any events that have already occurred do not show up.

I am ordering the events by their date, in fact, here is the bit of code:

$sql = "SELECT * FROM weeklyUpdate ORDER BY event_Date";
$result = mysql_query($sql, $connection) or die ("<p>Couldn't execute Weekly.");

while ($Myresult = mysql_fetch_array($result)) {
...
}

Okay, so now that you've seen this! I want to be able to add some sort of statement that says "SELECT... WHERE event_Date >= $todaysDate..." something like this, that would compare the dates!

The dates are saved in this format: - so today's date would be 04-19.

Anything you could do to help would be MOST appreciated!

[iceiceboom]

This should do the trick...

$sql = "SELECT * FROM weeklyUpdate ORDER BY event_Date"; 
$result = mysql_query($sql, $connection) or die ("<p>Couldn't execute Weekly."); 

while ($Myresult = mysql_fetch_array($result)) { 
  $Myresult[event_Date] = str_replace("-", "", $Myresult[event_Date];
  $today = date("md");
  if ($Myresult[event_Date]>=$today) {
    ...
  }
}