php mysql dates
| From: | Irm Jr | Date: | Wed, 28 Jul 2004 21:30:24 +0000 |
| Subject: | php mysql dates | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-35487@lists.php.net to get a copy of this message | ||
Hi all, currently I have a form which prompts for the user to choose a
date. The dropdown lists are stored into variables:
$month //e.g. January, February, ...
$day //e.g 1 - 31
$year //e.g. 2004 (four digits)
then combined into
$articleDate
How can I manipulate this variable to be in such a format that I can
insert the information into a DATE column in a mySQL database.
Dates are a bit of a mystery to me as PHP and MySQL handle them
differently. Your help is appreciated.
Thanks