#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Mar 2000
    Posts
    13
    Rep Power
    0
    i'm new to php/mysql. how do you get the results from a query to be listed alphabetically? thanks.
  2. #2
  3. No Profile Picture
    Apprentice Deity
    Devshed Loyal (3000 - 3499 posts)

    Join Date
    Jul 1999
    Location
    Niagara Falls (On the wrong side of the gorge)
    Posts
    3,237
    Rep Power
    18
    select * from table order by some_column

    This sorts ascending. You can add the DESC keywork behind the column name to sort descending.

IMN logo majestic logo threadwatch logo seochat tools logo