Re: Counting countries
Jochen Wiedmann <[email protected]>
| Newsgroups | gmane.comp.db.mysql.perl |
|---|---|
| Message-ID | <[email protected]> |
Bruce Therrien wrote:
> Trying to count the number of countries in a MySQL database.
> Each client has a country entered, and we want to add the total
> countries we are in and display on our site.
Are you sure, that you do not simply need the query
SELECT COUNT(*), country FROM $tablename GROUP BY country
and then read the counts (column 0) and the country names
(column 1)?
Jochen
--
http://lilypie.com/baby1/050423/1/5/1/+1
--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/[email protected]