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

    Join Date
    Jun 2000
    Posts
    1
    Rep Power
    0
    How I can make a select order by a upward field
    Thanks
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Location
    London, England
    Posts
    251
    Rep Power
    14
    SELECT *
    FROM table
    ORDER BY fieldname DESC

    Is this what you mean by an "upward field"???

    Or use ASC instead of DESC to reverse the sort order.

Similar Threads

  1. select radio button upon text field focus
    By robee in forum HTML Programming
    Replies: 2
    Last Post: August 26th, 2003, 08:37 PM
  2. field order for adding to tables
    By karsh44 in forum ASP Programming
    Replies: 5
    Last Post: June 10th, 2003, 01:34 PM
  3. randomly select from field?
    By timsharpe in forum PHP Development
    Replies: 1
    Last Post: May 1st, 2003, 10:04 AM
  4. Replies: 8
    Last Post: January 24th, 2003, 09:06 AM
  5. Database design question
    By mcsimon in forum Dev Shed Lounge
    Replies: 2
    Last Post: August 5th, 2001, 12:17 AM

IMN logo majestic logo threadwatch logo seochat tools logo