mysql COUNT row results
| From: | Ron Piggott | Date: | Thu, 23 Jun 2011 05:14:38 +0000 |
| Subject: | mysql COUNT row results | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-47864@lists.php.net to get a copy of this message | ||
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 the result is allowing only 1 to be selected. My desire is to have
the the COUNT result appended to each row.
Thoughts anyone? Ron
The Verse of the Day
“Encouragement from God’s Word”
http://www.TheVerseOfTheDay.info