[RESOLVED] Query MySql Database

[transfield]

Hello,
I've got a field in a MySql database that I'd like to query. This field contains names of people & there are some duplicates as well. The end result of my query should look like this:-

NAME		NUMBER OF RECORDS
Jonh		2 records
Alice		4 records
Builder		8 records
Yahoo		5 records

How do I write the SELECT statement & how do I display the results? I already know how to connect to the database so we can skip that part.

Thanks a lot.

[devinemke]

$result = mysql_query('SELECT name, COUNT(name) AS count FROM table GROUP BY name') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
  echo $row['name'] . ' ' . $row['count'] . ' records<br>';
}

[transfield]

Thanks a lot devinemke. The code works fine. Exactly what I was looking for. I appreciate your help on this matter.

Warm Regards.