I have a php site I built in dreamweaver. I've been struggling with this newbie question - I have a form that submits into a MYSQL database. Most of the text fields on the form are required (I have validation rules on them). But some of the form text fields don't need to be required, so there is no validation in them. But when the form is submitted, I get the error message:
SQL error: Column 'my_field' cannot be null.
I went into the insert record wizard and set a default value for the fields that are optional (that aren't required), but I still get the error message. Should I go into the database and chnage the value from NOT NULL to NULL? Should I take the default value out or leave it in? Thanks for any suggestions.