[eluser]Nathan Pitman (Nine Four)[/eluser]
Hi Doosje, thanks for the quick response. I think I just worked out my error. In my select that occured prior to the order_by I was formatting the date column in question and this was being done 'prior' to the order_by.
So I was doing:
Code:
$select = "DATE_FORMAT(date_prod1, '%d/%m/%Y') AS date_prod1";
and this was returning the data in a different format to which it was stored, prior to the order_by. By changing my select to:
Code:
$select = "DATE_FORMAT(date_prod1, '%d/%m/%Y') AS fdate_prod1";
Note the different variable name for the formatted date, I have fixed the problem! I guess it's one of those scenarios where posting the question helps you to see the actual problem! Thanks for your help regardless! Much appreciated.
Nathan