GoFuckYourself.com - Adult Webmaster Forum - View Single Post - PHP/MySQL question: how do you sort posts by date AND views?

Varius · 04-30-2009, 05:37 PM

select from_unixtime(time,"%Y-%m-%d") as date, views, title from test group by time order by date desc, views desc;

EDIT: as sarettah said while I was off taking a shower

04-30-2009, 05:37 PM
Varius Confirmed User Industry Role: Join Date: Jun 2004 Location: New York, NY Posts: 6,890	select from_unixtime(time,"%Y-%m-%d") as date, views, title from test group by time order by date desc, views desc; EDIT: as sarettah said while I was off taking a shower __________________ Skype variuscr - Email varius AT gmail