I'M trying to sort date but don't know how to start

[spaceplane]

I'M using mysql to store some event. An event contain a starting date, an ending date a description , the event title, occurence(number of time that this event repeat it self ex each week or month)... and three other information. Now I call a select all from my database order by starting date so like that all my event are sorted by starting date. Now I want to sort the ending date that where I get stuck and don't have a clue on how to do it...
like right now It give me
2003-01-00 2003-01-00 that an event that will be on jan 2003 that why 00 at days

2003-01-00 2003-01-00
2003-01-00 2004-05-00
2003-01-00 2003-02-00
2003-01-00 2003-01-00
that what it giving me when I select it from database but in a calendar it would be nicer if I could show it that the ending date are sorted too but I did try a lot of if and while and for but nothing work if anyone have a clue
thanks for trying helping

ps if needing more information just ask I will give my best to explain it better... I'm not the best in english writing sorry

thanks again

[spaceplane]

I did a big code to do it but it doesn't inverse anything and I'm wondering why
$yo = true;
while($yo)
{
$yo = false;

for ($i=0;$i < count($DateDebutTab);$i++)
    {
    if ($evenement[$i][DateDebut] == $evenement[($i + 1)][DateDebut])
       {
        $tempP = explode("-",$evenement[$i][DateFin]);
        $tempD = Explode("-",$evenement[($i + 1)][DateFin]);
        echo $tempP[0]."<br>";
        echo $tempD[0]."<br>";

//-------------doesnt go in here where it should go-----------------
if (((int)$tempD[0]) < ((int)$TempP[0]))
{

             $event[DateDebut] = $evenement[$i][DateDebut];
             $evenement[$i][DateDebut] = $evenement[($i + 1)][DateDebut];
             $evenement[($i + 1)][DateDebut] = $event[DateDebut];
             $event[DateFin] =  $evenement[$i][DateFin];
             $evenement[$i][DateFin] =  $evenement[($i + 1)][DateFin];
             $evenement[($i + 1)][DateFin] = $event[DateFin];
             $yo = true;

            }   
         else
            {
             if (((int)$TempP[0]) == ((int)$tempD[0]))
                 {
                  if (((int)$TempP[1]) > ((int)$tempD[1]))
                     {
                      $event[DateDebut] = $evenement[$i][DateDebut];
                      $evenement[$i][DateDebut] = $evenement[($i + 1)][DateDebut];
                      $evenement[($i + 1)][DateDebut] = $event[DateDebut];
                      $event[DateFin] =  $evenement[$i][DateFin];
                      $evenement[$i][DateFin] =  $evenement[($i + 1)][DateFin];
                      $evenement[($i + 1)][DateFin] = $event[DateFin];
                      $yo = true;
                     }
                  else
                     {
                      if (((int)$TempP[1]) == ((int)$tempD[1]))
                         {
                          if (((int)$TempP[2]) > ((int)$tempD[2]))
                             {
                              $event[DateDebut] = $evenement[$i][DateDebut];
                              $evenement[$i][DateDebut] = $evenement[($i + 1)][DateDebut];
                              $evenement[($i + 1)][DateDebut] = $event[DateDebut];
                              $event[DateFin] =  $evenement[$i][DateFin];
                              $evenement[$i][DateFin] =  $evenement[($i + 1)][DateFin];
                              $evenement[($i + 1)][DateFin] = $event[DateFin];
                              $yo = true;
                             }
                         }
                     }
                 } 
            }
        }
    }
}in other word it look at the first one and inverse with the second one if the ending date of the second one is earlir than the first one

only if the starting date are the same