Reply to thread

Message: <blockquote data-quote="JayC" data-source="post: 379288" data-attributes="member: 36373">You will want to do either:SELECT * FROM events ORDER BY timestamp ASCWhich makes the outcome this:257ORSELECT * FROM events ORDER BY timestamp DESCWhich makes the outcome this:752Make sure you add "LIMIT 10" or however many you want at the end of the statement:SELECT * FROM events ORDER BY timestamp DESC LIMIT 10and if you would like to keep track of all your events that are active/past events then have a column in the events table like "active" and do this:active int 11 0 NOT NULL default 1SELECT * FROM events WHERE `active` = '1' ORDER BY timestamp DESC LIMIT 1</blockquote>