Order more than one column

[The Little Guy]

I am trying to order my results, and I need to order by two colums I have this:

$thread1 = "SELECT * FROM threads WHERE idnum='$threadnum' ORDER BY date AND ORDER BY time DESC"; 

It doesn't work

Is there a better way to get this to order?

I would like it to be ordered by date, then by time.

[chazzy]

you mean this...

 $thread1 = "SELECT * FROM threads WHERE idnum='$threadnum' ORDER BY date, time DESC"; 

I wonder though why date and time are two different fields?

[The Little Guy]

So when I compair, There are times I need just the time, and times I need just the date.

[chazzy]

there are time extraction functions that you can use to compare.