Hi folks —

I'm collecting site visitors' comments using a form and bouncing selected fields from each record back into a table at the bottom of the page. I'm date-stamping each submission using NOW() into a date-time field, which is set to be the db index. All is hunky dory, except that I want to display the latest records at the top of the table, not the earliest. And left to its own devices, the db gives me the earliest at the top. Can anyone suggest a way of reversing the order?

Many thanks.

order by

You can add DESC to the end of the sql statement used to select the table, if you also use ORDER BY, which will sort it in reverse order.

Many thanks to you both.