count and fetch rows in php

Question

i have a table in my mysql database named (names) now everyone can save their real names

now i want to query this table and find out how many times these names used

forexample the output should be :

Jakob (20) Jenny (17)

now this is my own code :

    list($usernames) =mysql_fetch_row(mysql_query('SELECT name FROM table_user GROUP BY name ORDER BY COUNT(name) DESC LIMIT 50 '));
    list($c) =mysql_num_rows(mysql_query('SELECT COUNT(name) FROM table_user GROUP BY name '));

    print $usernames.'('.$c.')'

is this a correct approach ?!

Why are u using DESC LIMIT 50?

Mohit Jain
– Mohit Jain

2010-04-27 12:21:33 +00:00
Commented Apr 27, 2010 at 12:21 — Mohit Jain
– Mohit Jain, Commented Apr 27, 2010 at 12:21

nik · Accepted Answer · 2010-04-27 12:44:10Z

5

You can use one select query for this:

$sel_query=mysql_query("SELECT COUNT(name) AS nums, name FROM table_user GROUP BY name");

For outputting, you can use something like this:

while($fetch=mysql_fetch_array($sel_query))
{
   echo $fetch['name']."( ".$fetch['nums']." ) ";
}

edited Apr 27, 2010 at 12:44

answered Apr 27, 2010 at 12:20

nik

3,6783 gold badges24 silver badges34 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

count and fetch rows in php

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related