SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Enthusiast nixon's Avatar
    Join Date
    May 2003
    Location
    Australia
    Posts
    41
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Question reversing table id

    I have been using the below piece of script to show data according to id in a table. I want to display the last id number at the top of the table and the first at the bottom when viewed. It must only be a small change but I don't know it? Here is the script I am using currently, any help appreciated:

    //Display the text of each job in a table
    $sql = "select * from techjob1 order by ID ASC";
    $result = mysql_query($sql) or die(mysql_error());

  2. #2
    Sidewalking anode's Avatar
    Join Date
    Mar 2001
    Location
    Philadelphia, US
    Posts
    2,205
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Change ASC(ascending) to DESC(descending.)
    TuitionFree a free library for the self-taught
    Anode Says... Blogging For Your Pleasure


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
  •