Counting GROUP BY Data in PHP

Counting GROUP BY Data in PHP

Hello there Kenny,

Group By in SQL is not the solution to what you want to achieve. Group by function of SQL only groups your data according to the specified field you have chosen. If you want to achieve what you want, use the COUNT function of SQL. It lets you count the number of the selected field you have grouped by. To illustrate this, take a look with the code below.

SELECT au_id, COUNT(*) as “num_books”  from title_authors  GROUP BY au_id;

If you want to learn more with SQL you can come to this site:

Hope this helps you,

Regards Roland.