Forgot to mention... you can check it for validity easily using this method
as well:
if (checkdate($frmStartMonth,$frmStartDay,$frmStartYear)) {
echo "You can enter dates correctly. Well done!";
} else {
echo "Please visit
http://i-am-a-llama.com/explain-to-me-how-dates-work.html";
}
Cheers
Jon
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Sent: 23 January 2001 12:16
To: [EMAIL PROTECTED]
Subject: Sorting a date
Hi,
I would like to sort, when displaying, an "European Date" with mysql.
Anyone can give me some hints ?
The date format looks so like :
01.02.2001
03.12.2000
22.11.2000
and is stored in a simple field text
(first FEB 2001)
Thanks
GPo
---------------------------------------------------------------------
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
---------------------------------------------------------------------
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