INTERVAL 1 DAY - reverse to new > oldest

Databases
1

I have a page showing incidents that occur when… ok, just incidents

On that page on the top is the most recent incidents

and under that there is a list of incidents that happened last 24 hours

I have the script and it works except it shows the list with the oldest on top and the second most recent
at the bottom

How can I reverse so the second most resent is on top and oldest at the bottom

This is my code

SELECT * FROM `incidents` WHERE time >= SYSDATE() - INTERVAL 1 DAY
2

add an ORDER BY clause to your SELECT statement

:slight_smile: