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
mysql stores date as -mm-dd that is how the date should be entered into the form If entered in another format, you can reformat it. - Original Message - From: "Mike Tuller" <[EMAIL PROTECTED]> To: "php mailing list list" <[EMAIL PROTECTED]> Sent: Thursday, February 20, 2003 4:43 PM S