I have come across a problem when trying to order certain results by their timestamp value.
I would like these results displayed from the newest, to the oldest based on the timestamp values.
So to explain this, imagine that there were 3 results:
2012-07-11 17:34:57
2012-07-11 17:33:28
2012-07-11 17:33:07
This result set would be what I would require, but given the following query
SELECT timestamp
FROM randomTable
ORDER BY timestamp ASC
I get:
2012-07-11 17:34:57
2012-07-11 17:33:07
2012-07-11 17:33:28
This is as it is sorted by numerical value and 07 comes before 28.
If i sort in descending order I get
2012-07-11 17:33:07
2012-07-11 17:33:28
2012-07-11 17:34:57
Which is what I am looking for... But it is in reverse.
So my question is fairly simple, how could I sort these values in ascending order as I have described?
EDIT:
EDIT2:
CREATE TABLE `user_quotations` (
`id` int(100) NOT NULL AUTO_INCREMENT,
`quoteNumber` int(100) NOT NULL,
`lastModified` datetime NOT NULL,
`userId` int(100) NOT NULL,
`manufacturer` varchar(250) COLLATE latin1_general_ci NOT NULL,
`modelNumber` varchar(250) COLLATE latin1_general_ci NOT NULL,
`productDesc` varchar(1000) COLLATE latin1_general_ci NOT NULL,
`timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `quoteNumber` (`quoteNumber`,`lastModified`,`userId`,`manufacturer`,`modelNumber`,`timestamp`),
KEY `productDesc` (`productDesc`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci