Posted by Mark D. Smith on 04/18/06 13:01

Hi

i have some data which i can read ok but i need to display by date posted.
Problem is the date is stored in a field as text DD/MM/YY

using ORDER BY date_posted ASC does not give desired effect as it seems to
use only the DD

example of current output.

05/04/06
05/04/06
05/04/06
05/04/06
16/01/06
16/01/06
22/03/06
23/03/06
24/03/06

is there a way (otherthan re writing all the dates in database) to sort the
dates by order ?

Mark

• Next in forum: installing php 5, mysql 4 and apache 2.0.55
• Prev in forum: Re: simple PHP/MySQL shopping cart ?
• Thread view: order by

[Reply to this message]