RE: [PHP] Forms and MySql date

2003-02-21 Thread v0idnull
e = $_POST["month"]."-".$_POST["date"]."-".$_POST["year"]; -Original Message- From: Frank Keessen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:21 AM To: Philip Hallstrom Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Forms and MySql date Hi,

RE: [PHP] Forms and MySql date

2003-02-21 Thread v0idnull
."-".$_POST["year"]; -Original Message- From: Frank Keessen [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 1:21 AM To: Philip Hallstrom Cc: [EMAIL PROTECTED] Subject: Re: [PHP] Forms and MySql date Hi, You can let the users enter a date as 20-02-2003 into a t

Re: [PHP] Forms and MySql date

2003-02-20 Thread Frank Keessen
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, Fran

Re: [PHP] Forms and MySql date

2003-02-20 Thread Rick Emery
rsday, February 20, 2003 4:43 PM Subject: [PHP] Forms and MySql date 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

[PHP] Forms and MySql date

2003-02-20 Thread Mike Tuller
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 th