reverse order of query
Posted: Thu Mar 05, 2009 7:09 am
I have a mysql query within a php script:
My problem is that I need to use the 3 most recent dates BUT IN REVERSE order.
If I try the "ASC" command in the query, it returns the 3 oldest dates BUT from the total of 20 results, therefore the three dates I need do not appear.
Is there a way to reverse the order of the three rows returned by my query from php??
If "LIMIT" command weren't used, the query would return about 20 results starting with the most recent date. But since LIMIT is used it returns the 3 most recent dates.SELECT * FROM table1 WHERE ticker = 'CBU' AND `date` < '2008-01-31' ORDER BY `date` DESC LIMIT 3
My problem is that I need to use the 3 most recent dates BUT IN REVERSE order.
If I try the "ASC" command in the query, it returns the 3 oldest dates BUT from the total of 20 results, therefore the three dates I need do not appear.
Is there a way to reverse the order of the three rows returned by my query from php??