I have some fields set up in my MySQL database table as tinyint(5) The problem is that it will not except a NULL unless I specifically tell it NULL. I have a form that allows for input. When submitted, it updates the database. If the field on the form is empty, it still puts a "0" (zero) into that field in the database. I thought that would only happen if it was set to NOT NULL. The only way that I can get around this, at the moment, is to set the field up as some "char" like "varchar". I want it to me an "int" (tinyint) field and to be able to be empty if the form field is empty.
Thank You for your response Steve --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
