Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2003
    Posts
    2

    Question Unanswered: Select query Help for newbie Please

    Can someone help me with this one please I'm pretty new to MYSQL

    I have a database with one table MEMBERS

    there are 2 fields relevant to my query

    COUNTRY, MEMBERNAME

    I want to do the following

    List the COUNTRY names alphabetically

    A-COUNTRY
    B-COUNTRY
    C-COUNTRY

    and display how many MEMBERNAME there are per COUNTRY

    In esscence I want to display results by counting the number of rows per COUNTRY that contain a MEMBERNAME so that I wind up with something like the following


    USA 630 Members
    Ireland 330 Members
    Taiwan 400 Members

    etc.


    Thanks for you help in advance

  2. #2
    Join Date
    Jun 2003
    Posts
    2
    Never mind --------got it sorted thanks

  3. #3
    Join Date
    Jun 2003
    Posts
    5
    How ?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •