Self sorting table(top scorer)

I've made a form where the user, can choose a name from a dropdown menu and I've "connected" the form through ChronoConnectivity. My question is if it's possible to make the chioce of the user to duplicate itself and then sort iself like a top scorer table? ex.

If I submit four times with the name Jimmie and one time with the name Adam, the result would be

1.Jimmie 4
2.Adam 1

Thanks!

Hi Tjekov,

You can do this with the ORDER box in the Connection setup.

Bob

Ok, thanks for helping me.

I'm not sure how to make it though. Is it enough with only one field? How should the code in the body look like? I can't make it work with the counting, if i choose Jimmie three times I would like it to say Jimmie 3 and not Jimmie Jimmie Jimmie.

Hi Tjekov,

I think we've had that before. The answer may be in the forums here, otherwise you'll need to check the MySQL manual for GROUP BY.

Bob