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