Forums

Self sorting table(top scorer)

tjekov 14 Apr, 2010
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!
GreyHead 14 Apr, 2010
Hi Tjekov,

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

Bob
tjekov 16 Apr, 2010
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.
GreyHead 16 Apr, 2010
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
This topic is locked and no more replies can be posted.