SQL counting rows with matching value

Question

I have a table with the following values:

name_table

ID  Name  
1   Bob  
2   James  
3   Bob  
4   Joe

I am trying to do a search where it will give me the list names and how many times the name was found. What I am looking for is a result like this:

Bob 2  James 1  Joe 1

The code:

(connection info)  
$query = "SELECT name, count(*) FROM name_table GROUP BY name;  
$result = mysqli_query($connection, $query) or die (Could not execute query"); 
while ($row = mysqli_fetch_assoc ($result)) 
echo ("$row['name']");

It is showing me the names but not the count.

Gordon, forgive it's a typo, its mysqli_error I use it in hopes of getting something to give me an idea of what is not working, even if it's just a line number to give me a place to look. I do this as a hobby. :) — Grand Poobah, Oct 06 '18 at 15:47
You are missing a closing " from the 1st line of your code (see the syntax highlighting). — Shadow, Oct 06 '18 at 16:00
And you are not fetching the results. See duplicate question. — Shadow, Oct 06 '18 at 16:06
Shadow, I did search. Perhaps I did not recognize it, could I get a link perhaps? — Grand Poobah, Oct 06 '18 at 16:10

score 0 · Answer 1 · answered Oct 06 '18 at 16:01

0

$query="SELECT name, count(name) FROM name_table GROUP BY name ORDER BY name ASC;

answered Oct 06 '18 at 16:01

Osama

2,912
1
12
15

Osama, thank you, I closed the statement but still no joy. – Grand Poobah Oct 06 '18 at 16:09

SQL counting rows with matching value

1 Answers1