NYCPHP Meetup

[nycphp-talk] SQL Select

Peter Sawczynec ps at pswebcode.com
Mon Oct 16 14:05:38 EDT 2006


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>


More information about the talk mailing list