Counting GROUP BY Data in PHP

Asked By kenny gaitan 20 points N/A Posted on - 04/12/2012

I’ve been using GROUP BY in my query but I can’t count the data being grouped. Can anyone help me on how to count the number of grouped data? Thanks. 

 

• Status: Open
• Question Views: 1041
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: PHP

Answered By Ronald B Cline 45 points N/A #102888

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. 

About Ronald B Cline

Questions
18

Answers
106

Best Answers
21

• Vote Up 0 Vote Down

• Posted on - 03/26/2013
• Question Category: PHP