ORDER BY - Brain Fart!

[ChrAyr]

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!

[blazes]

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

[ChrAyr]

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!

[nobody]

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 :)