If you're looking for a count of ALL records, why do you want to append that
to EACH record?
Now if you're looking for a count of subscribers who have certain attributes
(ie, unique groups of subscribers), then you would use a group by clause and
include the attributes that define the group in
-Original Message-
From: Geoff Lane
Sent: Thursday, June 23, 2011 2:15 AM
To: Ron Piggott
Cc: php-db@lists.php.net
Subject: Re: mysql COUNT row results
Hi Ron,
On Thursday, June 23, 2011, 6:14:38 AM, you wrote:
Is there a way that
SELECT COUNT(auto_increment) as total_subscribers
Hi Ron,
On Thursday, June 23, 2011, 6:14:38 AM, you wrote:
> Is there a way that
> SELECT COUNT(auto_increment) as total_subscribers , `email` FROM `table`
> may exist within the same query and provide more than 1 row of
> search results? When I run a query like this the COUNT portion of
>