Quote:
Originally Posted by quantum-x
SELECT * FROM `table` ORDER BY `time` DESC,`views` DESC
.. ?
|
That was their first suggestion, didn't work :/
Even tried: SELECT * FROM `table`, DATE_FORMAT(`time`, '%M %e %Y') as formatTime ORDER BY `formatTime` DESC,`views` DESC
with no luck. The first one didn't sort them by views at all, and the 2nd one had the ones with most views at the top no matter what date.
Maybe I could just sort everything by views, and then as it's looping through throw each post into the group which date it belongs to..?