[RESOLVED] query order

[msnhockey]

hey all,

trying to add the word time with the ORDER sequence..

here is what i have now

$result_schedules_scores = mysql_query("SELECT * FROM schedule_scores WHERE "

."(team1 = '$id' OR team2 = '$id') "

."AND season = '$sid' "

    ."AND team1_score > '-' "

."ORDER BY date DESC LIMIT 1");

i want to order by date and then order by time in a DESC way

any suggestions appriciated

mike

[NogDog]

. . . ORDER BY date DESC, time DESC LIMIT 1

[msnhockey]

worked like a charm...
i kept putting ORDER BY date, time

thanks.