When you get the results of the query use mysql_num_rows(res) to get
the number of groups. Or if you only want to return the number of
groups in a query use something like. select count(distinct field)
On Wed, 20 Oct 2004 03:03:47 +0200, Marco <brbromo@stripped> wrote:
> I would like to count all of the resulting rows of my query.
> But my query contains a "group by", so
> select count(*) from table group by field
> will select an individual group count for each group. Instead, I would
> like to count the number of groups.
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1
|• counting rows||Marco||20 Oct|
| • Re: counting rows||Eric Bergen||20 Oct|