timestamp sort in descending order??

[cheryl]

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]

ORDER BY `timestamp` DESC

~Phil~

[vinyl-junkie]

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.