RE: [PHP] Forms and MySql date

2003-02-21 Thread v0idnull
- 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 textfield with the name $userdate Then you can use this function

RE: [PHP] Forms and MySql date

2003-02-21 Thread v0idnull
I apologize the correct order is -MM-DD so you would do: $mysqldate = $_POST[year].-.$_POST[month].-.$_POST[date]; -Original Message- From: v0idnull [mailto:[EMAIL PROTECTED]] Sent: Friday, February 21, 2003 4:37 AM To: [EMAIL PROTECTED] Subject: RE: [PHP] Forms and MySql date

[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

Re: [PHP] Forms and MySql date

2003-02-20 Thread Rick Emery
: [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 yymmdd. I could change the column to varchar

Re: [PHP] Forms and MySql date

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