Hello! May be you are using data as text field or date is being stored in 3 separate columns. Tell me if I am right. You will need to store the date as date data type and will be automatically sorted.
Regards ~~~~~~~~~~~ Tahir Ata Barry BestPriceHost.com The Hosting With 3 MySQL Databases ~~~~~~~~~~~ 5/7/2002 6:01:09 PM, Nick Wilson <[EMAIL PROTECTED]> wrote: >-----BEGIN PGP SIGNED MESSAGE----- >Hash: SHA1 > > >* and then Victoria Reznichenko declared.... >> NW> I've been searching for a solution to the following: >> >> NW> Is there an easy way to order by date (YYYY - MM - DD), at the moment my >> NW> results are coming back with the *day* ordered but not the whole date >> NW> like this: >> >> NW> 02 02 2002 >> NW> 03 03 2005 >> NW> 18 02 2003 >> >> NW> See what I mean? >> >> 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 not correct in your SQL statement. > >Right. here is the db schema: Feel free to berate me if I'm missing the >obvious :-) >CREATE TABLE iaadiplom_timetable >( > id INT NOT NULL AUTO_INCREMENT, > module ENUM('0', '1', '2', '3', '4', '5'), > week VARCHAR(255) NULL, > date DATE NOT NULL, > ektione VARCHAR(255) NULL, > title TEXT NULL, > teacher_id INT NULL, > PRIMARY KEY(id) >) > >and here is my select: > > $qry="SELECT id, module, week, "; > $qry.="DATE_FORMAT(date, \"%d %m %Y\") as date, "; > $qry.="ektione, title, teacher_id "; > $qry.="FROM $this->table "; > $qry.="WHERE module = '$module' "; > $qry.="ORDER BY date ASC"; > > >Thanks very much for the help! >- -- >Nick Wilson // www.explodingnet.com > > > >-----BEGIN PGP SIGNATURE----- >Version: GnuPG v1.0.6 (GNU/Linux) > >iD8DBQE819AVHpvrrTa6L5oRAtj2AJ9CFMVEZEyBZKxy7zhOoSmMDAWUrwCfelhu >UbSqDCWAxbYSgmGA2/u6OL8= >=qD2+ >-----END PGP SIGNATURE----- > >--------------------------------------------------------------------- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > Tahir Ata Barry CEO, Sulata iSoft http://www.sulata.com.pk --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php