Re: Blanks entering as zeros

The fields in the database that are adding zeros instead of blanks are of type INTEGER. You need to set them to Null instead of "". How do you do this without if's? Not sure. You should probably change the fields to type TEXT. Charles ----- Original Message ----- Sent: Monday, September 18, 2000 9:34 AM Subject: [PHP] Blanks entering as zeros Hello, This may be a simple question, but how do I stop blanks in a form from entering as zeros in the database? There are a lot of fields on this form, and I would rather not write twenty "if" versions of the insert. Thanks for your help. - - - - - - - - - - - - - - Scott Poarch GlobalHost.com - - - - - - - - - - - - - - -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net