Order by Date

Kol

Hi there.

I have modified a PHP calendar to display a couple of links on my homepage, as part of an "Upcoming Events" type thing.

The problem is, that the data isnt in any particular order in the database, and also data isnt removed from the calendar after the current date has passed. Therefore, my 6 "Upcoming Events" will never change!

I was thinking of using the dates to order them, they are in this format:

August 11, 2003
September 27, 2003
August 16, 2003
August 16, 2003
August 16, 2003

How would i be able to re-arange them (closest date to today first) and remove any dates which older than the current date?

Any help would be apreciated!

Thanks

Kol

I sorted the old posts get removed bit, by changing the date to YYYYMMDD, then comparing it with the current date.

However, i dont know how i could put them into order.

My code is below, well, it is sort of my code 😃

<html>
<?php
//always returns true so all records will be returned
function returnAll($item){
         if($item)
          return true;
}

     echo "<table>";
//displays record
function show_record($record){
         $eventNumber = $record["event_key"];
         $eventName = $record["event_name"];
         $eventYear = $record["event_year"];
         $eventDay = $record["event_day"];
         $eventMonth = $record["event_month"];

echo "<tr>
     <td><a href=\"calendar/viewEvent.php?eventNumber=$eventNumber\" class=\"viewall\">$eventName</a></td>
     <td><font class=\"viewall\">$eventMonth $eventDay, $eventYear</font></td></tr>";
}

// Include the FFDB library
include("calendar/ffdb.inc.php");

//open db or create new db
$db = new FFDB();
if (!$db->open("calendar/calendar"))
{
   // Define the database shema.
   // Note that the "last_name" field is our key.
   $schema = array(
      array("event_key", FFDB_INT, "key"),
      array("event_name", FFDB_STRING),
      array("event_description", FFDB_STRING),
      array("event_submitted_by", FFDB_STRING),
      array("event_month", FFDB_STRING),
      array("event_day", FFDB_INT),
      array("event_year", FFDB_INT)
   );

}

$result = $db->getbyfunction("returnAll", "event_key");

foreach($result as $item) {
if($count < 6){

/////////////
//remove entries which are too old...	
/////////////

switch($item['event_month']) {
	case "January": $month = 1; 
		break; 
	case "February": $month = 2; 
		break; 
	case "March": $month = 3; 
		break; 
	case "April": $month = 4; 
		break; 
	case "May": $month = 5; 
		break; 
	case "June": $month = 6; 
		break; 
	case "July": $month = 7; 
		break; 
	case "August": $month = 8; 
		break;
	case "September": $month = 9; 
		break; 
	case "October": $month = 10; 
		break; 
	case "November": $month = 11; 
		break; 
	case "December": $month = 12; 
		break;  

	default:;
}
$currentdate = date(Y).date(n).date(j);
$itemdate = $item['event_year'].$item['event_month'].$item['event_day'];

if ($currentdate < $itemdate){
	//it is in the future - show it...

	show_record($item);
	$count = $count + 1;
}else{
//its in the past...
}
}
}

echo "</table>";

?>

</BODY>
</HTML>

Can anyone help?

Thanks very much for your time!

Kol