Hi,
You can let the users enter a date as 20-02-2003 into a textfield with the
name $userdate
Then you can use this function to convert it;
$date_array = split("-", $userdate);
$mysqldate = $date_array[2]."-".$date_array[1]."-".$date_array[0];
Store $mysqldate into the database!
Regards,
Frank
----- Original Message -----
From: "Philip Hallstrom" <[EMAIL PROTECTED]>
To: "Mike Tuller" <[EMAIL PROTECTED]>
Cc: "php mailing list list" <[EMAIL PROTECTED]>
Sent: Thursday, February 20, 2003 11:48 PM
Subject: [PHP] Re: Forms and MySql date
> You could use the TO_DATE function to convert that text string into a
> date, or reformat it in PHP to yyyy-mm-dd which mysql will take
> automatically (at least I think so)
>
> On Thu, 20 Feb 2003, Mike Tuller wrote:
>
> > I have a form that I want to enter a date into a MySql database. I
> > currently have the column in the database set as Date, and can't seem
> > to get the date I enter into the text field to go into the database
> > using the format yymmdd. I could change the column to varchar, and then
> > it would enter, but this will be a database that I want to keep track
> > of purchases, and if it is entered in as text, I wouldn't be able to do
> > calculations such as showing how old something is.
> >
> > How can I have a text field where a person enters the date and have
> > that information entered into the database?
> >
> > Mike
> >
> >
> > --
> > PHP General Mailing List (http://www.php.net/)
> > To unsubscribe, visit: http://www.php.net/unsub.php
> >
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
