----- Original Message ----- From: Mike Brandonisio I'll take a wild guess. Maybe $email needs more testing like:
if ( strlen($email) >2) $email might be an empty string but still exist. Also if you have a default value set for the field in mysql, you do not need to set the field to get the default do not assign a value. Also do not assign an empty string like '' for the value or you will get a NULL value. Hi Mike, I'm checking for a min of 10 chars plus trimming, checking for illegal chars and the email format etc. I was assuming that if I inserted an empty string into 'email', it would use the default value specified. So, how do I make it use the default value? I've tried using NULL. Regards, Bob E. Community email addresses: Post message: php-list@yahoogroups.com Subscribe: [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] List owner: [EMAIL PROTECTED] Shortcut URL to this page: http://groups.yahoo.com/group/php-list Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-list/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/