View Full Version : timestamp sort in descending order??

06-09-2006, 12: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, 01:08 PM
ORDER BY `timestamp` DESC


06-10-2006, 05: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.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum