MySQL count()

[wattsin]

I want to list the person that shows up the most in order of count

for example this is the table

id from item_id to
1 bob 4 sarah
2 mike 2 tim
3 bob 1 evan
4 tom 4 sarah



I want it to display that

Sarah has two # 4's
then it would go in order
So tim and evan both have one 2 and 3

Is this possible...

Thanks so much, and sorry if this makes no sense at all

[longneck]

one of these two will give you the result you want:

select `to`
     , count(*) as theCount
  from theTable
group
    by `to`
order
    by theCount

select `to`
     , item_id
     , count(*) as theCount
  from theTable
group
    by `to`
     , item_id
order
    by theCount

[wattsin]

That worked great! Thanks!