...

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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum