[SOLVED] order by num, by date

[chick3n]

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.