The system set up that works is on OS X Leopard. PHP version 5.2.9 mysql version 5.1.33, Apache 2.2.11
The other is a Linix system using PHP v 5.2.8 Apache 2.2.3, mysql 5.0.45
In both databases the fields are set to allow null and default to null. In the setup from my mac when pages are viewed null is not displayed.
If it's a case where null needs to be cleared out is there an easy way to do this for all null fields?
When I view the both databases using phpmyadmin null is shown for fields with no value. When I look at my web pages when served from my computer null fields are just displayed blank which is what I want.