The forums have permanently moved to forum.kirupa.com. This forum will be kept around in read-only mode for archival purposes. To learn how to continue using your existing account on the new forums, check out this thread.


Results 1 to 4 of 4

Thread: ORDER BY - Brain Fart!

  1. #1

    ORDER BY - Brain Fart!

    I'm building a very small site where 3 fields are submitted and when they are recalled I need them to show up in DESC order from the newest entry on top to the oldest on bottom. I need a separate field in my database to have a number assigned to each entry that I can sort from, but I can't figure out how to do that. Make sense?

    Thanks!

  2. #2
    Make a column called id, set it to a primary key and to auto_increment.

  3. #3
    Quote Originally Posted by blazes View Post
    Make a column called id, set it to a primary key and to auto_increment.

    Ahhh brilliant! That was what i was forgetting.. the id column. I'm a bit rusty on my PHP/MySQL these days. Thank you very much!

  4. #4
    There's pretty much never a case where you don't want an ID field, might as well get used to slapping it in to your tables

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

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

Home About kirupa.com Meet the Moderators Advertise

 Link to Us

 Credits

Copyright 1999 - 2012