How to order MySQL records by Unix timestamps in descending order?

Question

How do I order records in a PHP query to MySQL by a field that contains TIME() timestamps in descending order?

Answer 1

Use the ORDER BY clause like this:

SELECT …
FROM …
ORDER BY timestamp_field DESC