On Wed, 5 Dec 2001 09:01, [EMAIL PROTECTED] wrote:
> 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
If memory serves me correctly, you need to test for an empty variable; if
empty, assign it the value NULL (no quotes around it!)
David Robley Techno-JoaT, Web Maintainer, Mail List Admin, etc
CENTRE FOR INJURY STUDIES Flinders University, SOUTH AUSTRALIA
Buy Land Now. It's Not Being Made Any More.
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]