Ordering by date (PHP and MySQL)

[resetreset]

If I have a table with fields in it, eg "Item", and I have a "date" field, I want to store the date next to an item, and then, if I want, get the table data sorted by the date, i.e. I'll know which item was sold the newest. How do I put the date into the table, and how do I order it by date in the SQL statement?

Thanks.

Continue reading...