#1
  1. No Profile Picture
    tucats
    Guest
    Devshed Newbie (0 - 499 posts)
    I have forgotten how to list my results alphabetically... Can someone refresh my memory... Please...

    example:

    $result = mysql_query("SELECT * FROM $state WHERE City = '$cities'",$db);

    $count = mysql_num_rows($result);

    $today = getdate();

    $month = $today[month];

    $day = $today[mday];

    $year = $today[year];

    if ($myrow = mysql_fetch_array($result)) {

    .... blah, blah, blah...


    Thank you so much and have a great Christmas

  2. #2
  3. No Profile Picture
    PAV
    Guest
    Devshed Newbie (0 - 499 posts)
    SELECT * FROM $state WHERE City = '$cities' ORDER BY City ASC [or DESC]

    Merry Christmas and happy 2000 to all of you too!

Similar Threads

  1. alphabetical indexing using MYSQL query?
    By kalmaster in forum MySQL Help
    Replies: 14
    Last Post: January 7th, 2004, 03:43 PM
  2. alphabetical indexing: removing articles and sorting?
    By kalmaster in forum PHP Development
    Replies: 1
    Last Post: January 6th, 2004, 04:27 PM
  3. what is alphabetical sort?
    By yguo080 in forum XML Programming
    Replies: 1
    Last Post: November 8th, 2003, 01:57 AM
  4. Replies: 5
    Last Post: September 13th, 2003, 09:16 PM
  5. problem specifying alphabetical listing from table
    By horstuff in forum PHP Development
    Replies: 4
    Last Post: March 20th, 2003, 08:49 PM

IMN logo majestic logo threadwatch logo seochat tools logo