Count users from 1 with users from MySQL server

Question

I have a user table in the admin panel that will echo all users to a table, but in the first row of the table I want to echo the number they are so you can easily just scroll to the bottom and find how many users there are, so I want the format to be like this..

#Number | User

    1 | ImSchnebz<br>
    2 | etc...<br>
    3 | etc...

add a counter and start display it inside the loop and increment it !! — Abhik Chakraborty, Mar 18 '14 at 11:55
@AbhikChakraborty Yeah I figured out that already, the thing is, I have no clue on how to do it.. — Schnebz, Mar 18 '14 at 11:58
I think you can find the answer here: http://stackoverflow.com/questions/2520357/mysql-get-row-number-on-select — Roberto, Mar 18 '14 at 11:59

score 0 · Answer 1 · answered Mar 18 '14 at 11:59

0

try this

SELECT @cont := @cont +1, username from tableName

answered Mar 18 '14 at 11:59

user1844933

3,296
2
25
42

Count users from 1 with users from MySQL server

1 Answers1