View Full Version : timestamp sort in descending order??

06-09-2006, 01:47 PM
i have a system that captures registrations. the registrations are timestamped.

the default sort when i view the entire table is by name. how can i sort by the latest registration at the top??

i've tried to do ORDER BY [timestamp] DESC

does that work?

06-09-2006, 02:08 PM
ORDER BY `timestamp` DESC


06-10-2006, 06:48 PM
Is timestamp the name of your data element in your database table? If so, that's probably why you're having problems. That is a reserve word in MySQL. Change that data element name to something else and your query should work. BTW, you shouldn't have to put brackets around it in your query.