Simple Question: PHP, MySQL, HTML Form and NULL
| From: | sgibbs at vt dot globalhealth dot org | Date: | Tue, 04 Dec 2001 22:31:05 +0000 |
| Subject: | Simple Question: PHP, MySQL, HTML Form and NULL | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-76615@lists.php.net to get a copy of this message | ||
I have added a new column in an existing MYSQL table called "event_date" -
type: DATE, NULL default.
This database field will be filled if and when the field in the HTML form is
complete. When I added the new field to MySQL, it automatically assigned
NULL to all the existing records - which is what I wanted it to do.
I tested the HTML form, and when someone enters a date in the HTML form, the
date appears correctly in the table field. Perfect.
Now my question: When the HTML form date field is left blank and the form
is submitted, instead of putting "NULL" in the MySQL event_date field, I
found: 0000-00-00. Is this because the form is submitting an " " to the
database field?
Is there some kind of if/then statement I should use so that when the field
is empty, "NULL" will be entered into that table field?
Thank you, Shawna