NYCPHP Meetup

[Peter Sawczynec]

If I have a table with fields roughly like:
 
ID NAME ADDRESS CITY STATE COUNTRY
 
I would like to do a select that would give me output grouped like so
(including the quantity):
 
United States (1589)
   New York (1200)
   Los Angeles (200)
   Dallas (189)
Maldives (1)
France (123)
   Paris (111)
   Bordeaux (9)
   Orleans (3)
 
etc.
 
Thanks in advance if you've got this at your fingertips.
 
 
Warmest regards, 
 
Peter Sawczynec 
Technology Director 
PSWebcode 
_Design & Interface 
_Ecommerce 
_Database Management 
646.316.3678 
ps at pswebcode.com 
www.pswebcode.com <http://www.pswebcode.com/>  
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.nyphp.org/pipermail/talk/attachments/20061016/28874c01/attachment.html>