Using PHP and MySQL
I do not do a lot of custom inserting. I have a form and am using Dreamweaver CS5 to insert the form variables into a MySql table. Some of the form fields are optional. When I test this form and do not fill out a field, I get a Column 'colName' cannot be null.
I could I guess easily enough mark each of my columns with a default value of NULL but I'm afraid that when the table results are printed it will show NULL for that empty field.
How can I get form variables that do not have a value to show as an empty string in the database?