Re: Re: Order by date

2002-05-07 Thread Nick Wilson
-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, "; >^^^

Re: Re: Order by date

2002-05-07 Thread Victoria Reznichenko
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 someth