[RESOLVED] Ordering Results

[D_tunisia]

Wonder if anyone can help me out?

I've created a basic news posting script but I'm having trouble out putting the data from the SQL database in the way that I want to.

Basically there are two fields in the news table that I want to use to order the results which are output to the browser: they are "hits" (which is the total amount of times that the record has been viewed) and "date" (which is fairly straight forward!).

I want to output the results so that the records are shown in date order but the results within each date are ordered by the number of hits.

I hope I have explained this clearly enough!

Thanks in advance for any help!

[bough]

You can add in "order by" to your SQL to sort out the order of the selection

sql = "select date,hits from table1 order by date, hits"

should work

[D_tunisia]

Thanks! That worked!