Sorting a database from two colums ... HELP!!!

[Morten Jakobsen]

Hi, i got a minor problem .. trying to sort a few things out.
I'm saving a time stamp in my DB, where the hours and minutes are stored in eachh their own row like:
Hours in column: timehh
Minutes in column: timemm


My problem is when i sort it then it's not sorting right ..


The way it sorts now:
08:00
09:00
08:10
08:20
08:05


The way i want it to sort
08:00
08:05
08:10
08:20
09:00


This i my    query:
"SELECT * FROM timedate ORDER BY timehh AND timemm ASC"


Anyone got a quick fix?


I can post source if needed..

[phphelp]

Here is a quick fix for your query:

"SELECT * FROM timedate ORDER BY timehh, timemm"

[Morten Jakobsen]

Here is a quick fix for your query:

"SELECT * FROM timedate ORDER BY timehh, timemm"

thank you