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
