PDA

View Full Version : timestamp sort in descending order??



cheryl
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?

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

~Phil~

vinyl-junkie
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.