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

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    Yo ppl. I've got a downloads page powered by PHP3 (soon to be 4) and MySQL. I want to sort the d/l's by TimeStamp, but it outputs the oldest first, so the new d/l's are at the bottom of the page Is there a way to reverse this?
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 1999
    Location
    Seattle
    Posts
    133
    Rep Power
    16
    Just add this to your query (assuming that stamp is the name of the column continaing the timestamps):

    ORDER BY stamp DESC

    Don
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    May 2000
    Posts
    4
    Rep Power
    0
    i'm currently using this:
    SELECT * FROM files_art order by $srt limit $offset,$showamnt
    where the vars are user defined
    would using this:
    SELECT * FROM files_art order by $srt desc limit $offset,$showamnt
    work then?

Similar Threads

  1. Replies: 0
    Last Post: May 5th, 2003, 07:59 AM
  2. Ordering by reverse integers
    By jomohke in forum MySQL Help
    Replies: 2
    Last Post: April 15th, 2002, 08:52 AM
  3. Replies: 1
    Last Post: December 7th, 2001, 09:00 AM
  4. incorrect sorting of Unix timestamp
    By vladiator in forum MySQL Help
    Replies: 2
    Last Post: October 12th, 2001, 03:42 PM
  5. Reverse Ordering?
    By Andrew T in forum MySQL Help
    Replies: 1
    Last Post: November 29th, 1999, 08:47 AM

IMN logo majestic logo threadwatch logo seochat tools logo