Users ordered by Karma
You can order your data on different fields in the database. This example orders the users by karma. Users can earn karma by logging in to the site, contribute to the forum.
SELECT
karma, userName
FROM
users
WHERE
status = 'Active'
ORDER BY
karma DESC
| karma | userName |
| 96 | rory |
| 45 | joeri |
| 9 | len |
| 7 | Admin |
| 4 | demartin |
| 2 | vinayv |
| 2 | jgallego |
| 2 | estivenrpo |
| 1 | barsamj |
| 1 | mcarring |
| 1 | ian |
| 1 | hoan |
| 1 | bart |
| 1 | tineke |
| 1 | zoran035 |
| 1 | cjalain |
| 1 | SHEETAL |
| 1 | william |
| 1 | torque |
| 1 | gredenz |
| 1 | arjan |
| 0 | Visitor |