NYCPHP Meetup

[nycphp-talk] SQL Select

inforequest 1j0lkq002 at sneakemail.com
Mon Oct 16 16:16:21 EDT 2006


I think I saw something very much like this on a website here:  
http://dev.mysql.com/doc/refman/5.0/en/index.html

you may have to look around a bit.



Peter Sawczynec ps-at-pswebcode.com |nyphp dev/internal group use| wrote:

> 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 <mailto:ps at pswebcode.com> 
> www.pswebcode.com <http://www.pswebcode.com/>
>  
>
>------------------------------------------------------------------------
>
>_______________________________________________
>New York PHP Community Talk Mailing List
>http://lists.nyphp.org/mailman/listinfo/talk
>
>NYPHPCon 2006 Presentations Online
>http://www.nyphpcon.com
>
>Show Your Participation in New York PHP
>http://www.nyphp.org/show_participation.php
>  
>


-- 
-------------------------------------------------------------
Some say "Science is fact. Religion is faith. Magic is perception". I wonder, if what you witness is not reality, but your perception of reality, do you trust your perceptions as truth? Does that make the so-called scientist a religious magician?  --John Andrews Competitive Webmaster and SEO Blogging at http://www.johnon.com




More information about the talk mailing list