sorting mySQL data

adavis

I have a ball schedule in a mySQL table. I want to select the team (middle school or high school) and sport and then sort by date and time. So what's the select statement? Here's my first stab at it.

SELECT * FROM schedule
WHERE sport = '$sport' and grade = '$grade'
ORDER BY date time;

date is stored yyyy-mm-dd and time is hh:mm:ss on 24 hour clock.

Will this do the trick?

adavis

Here's what is sort of working:

SELECT *
FROM schedule
WHERE sport = '$sport' and grade = '$grade'
ORDER BY gametime and gamedate

However, it won't sort the time within the date. If I use just one or the other, it sorts, but with both, the time is in the order entered into the database and not the by gametime.

Lars_Berg

SELECT * 
FROM schedule 
WHERE sport = '$sport' and grade = '$grade' 
ORDER BY gamedate , gametime

Why two separate fields?

adavis

Yes, this is what I finally got to work late last night. I had never used the ORDER BY before, so was not sure of the correct syntax. I found a space, and, and comma between the 2 fields. The comma is what did what I needed which was sort by time then date.

Thanks