[SOLVED] Ordering

[Democreous]

I was wondering if it is possible to order a mysql query by two things.  I'm trying to order it using the date and the time, which are two separate fields, so it orders by the date, then if there are multiple dates, by the time.

 

 

right now it looks like this

	$sql = mysql_query("SELECT * FROM calendar_events WHERE event_date LIKE '____-$month-__' ORDER BY event_date && event_time ASC" );

 

One of the statements after ORDER doesn't work, and I have a feeling I cannot do this.

 

Any suggestions?

[Tyche]

use a comma instead of &&

 

ORDER BY event_date, event_time

[Democreous]

thanks a lot, exactly what I needed.