Re: Re: Order by date

Nick, Tuesday, May 07, 2002, 4:01:09 PM, you wrote: What is your column type? Why you don't use ORDER BY your_date_column in the SELECT statement? It should work, but I can say you exactly because I don't know your table structure. The other causes of wrong result might be that something is

Re: Re: Order by date

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 * and then Victoria Reznichenko declared NW and here is my select: NW $qry=SELECT id, module, week, ; NW $qry.=DATE_FORMAT(date, \%d %m %Y\) as date, ; The