PHP mySQL date ordering issue. Need Help Please!

[hookedupphat]

Hello everyone, long time reader, first time poster...

 

I'm having an issue with a calendar program I'm working on, it involves a mySQL database with a date field.  Basically I am pulling up every 'event' from the database that corresponds to a particular user.  I cannot seem to get them to order correctly.  Right now they are ordered by the month name, which will put August before december, and so on.  How can I get them to order chronologically, or at the very least manage it so I can call a particular month?

 

                       $courses = explode(",", $cid);

		foreach($courses as $i){
  			
		$sql .= "cid = '$i' OR ";

		}

		$sql = rtrim($sql, "OR ");

		$select_query="SELECT eid,cid,DATE_FORMAT(date, '%b. %D, %Y')AS date,name,type from courses_events WHERE ($sql) ORDER BY date ASC";

 

Hope someone can help, or at least point me in the right direction!  Thanks in advance!

[PFMaBiSmAd]

You need to ORDER BY the original column. When you use an alias name that is the same as the column name, the alias value is used. I would pick a different alias name.

[Wright]

Specific situations require specific methods my friend! Do as PF says or use PHP to manually order them!