order by

How can I use order by 2 times

See I want to order by paid and order by hits

I want paid at top of list and hits in DESC order after paid.

ORDER BY hits DESC and paid='1'

that didnt work....

I also reversed it and did

ORDER BY paid='1' and hits DESC

that didnt work either..

getting hits in DESC order and put paid on top is my issue, so if anyone out there can help me out that would be great....

multiple queries may be...

SELECT FROM table WHERE paid="1" ORDER BY hits DESC
SELECT FROM table WHERE paid="0" ORDER BY hits DESC

use single query and sort by PHP

SELECT * FROM table ORDER BY hits DESC

then use mysql_fetch_array() function. Now sort this array using krsort (key = paid) and u r done

second option reduces load on SQL server

MUCH SIMPLER (not sure though)

SELECT * FROM table ORDER BY hits, paid DESC

Good Luck
TommYNandA

Well I read up on the krsort and do not understand it at all.....

urghhhhhhhhh

not sure, maybe it was just your syntax?

ORDER BY paid DESC, hits DESC

would that work the way you want it?