simple(?): counting entries in table

[jogol]

hi experts,

i have a mysql table that looks like this:

name | serialno

with entries added it looks something like this:

johnny | 872346
patrick | 094884
franky | 349844
johnny | 934948
patrick | 493484
johnny | 349843

what i want to achieve is outputting like this (counting how many serialno a person has):

franky | 1
johnny | 3
patrick | 2

how would the SELECT query and the PHP code to output this result in a table look like?

thanks in advance,
jogol

[Weedpacket]

Go to your database software's documentation, and have a look in its chapters on SQL for COUNT and GROUP BY.

[jogol]

"SELECT name, COUNT(serialno) FROM table GROUP BY name ORDER BY name ASC"

thanks for the hint 🙂