chick3n Posted June 23, 2007 Share Posted June 23, 2007 I would like to sort my data by the total amount of 'clicks' for each date. Clicks are unsigned ints, Date is datetime So the dates would be DESC current -> previous, and the number of clicks would be ordered highest -> lowest by date. tom, 234 clicks, 2007-06-23 jim, 134 clicks, 2007-06-23 mike, 54 clicks, 2007-06-23 tom, 546 clicks, 2007-06-22 jim, 432 clicks, 2007-06-22 mike, 123 clicks, 2007-06-22 Thanks. --edit wow im an idiot, i solved it, couldnt have been any simpler. Link to comment https://forums.phpfreaks.com/topic/56867-solved-order-by-num-by-date/ Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.