SitePoint Sponsor

User Tag List

Results 1 to 3 of 3
  1. #1
    SitePoint Addict brain's Avatar
    Join Date
    Sep 2001
    Location
    Amsterdam
    Posts
    249
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    list values automatically in alphabetic order

    I have a page with the possibility to choose from a list with values. These values are generated from tblCity from a mySQL database. When inserting another place, the list extends with the inserted place but puts that place at the bottom of the list. But I want it to be alphabetic ordered. How can I let that happen ?

    Greetz Brain

  2. #2
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    tag this onto your sql:
    PHP Code:
    SELECT from table_name order by column_name ASC 
    Last edited by Defender1; Sep 6, 2001 at 02:37.
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*

  3. #3
    SitePoint Wizard Defender1's Avatar
    Join Date
    Apr 2001
    Location
    My Computer
    Posts
    2,808
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    ok, wtf.
    it wont' show the whole thing

    SELECT * from table_name order by column_name ASC
    Defender's Designs
    I'm Getting Married!

    Not-so-patiently awaiting Harry Potter Book 7 *sigh*


Bookmarks

Posting Permissions

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