>Nope, you change the field to not null then it won't allow null values in
>the database. Since the data already has null values, the Alter Table would
>probably fail.
I should have been clearer - change the text field to non-null - this will
cause the null entries to become empty strings (and hence your
mysql_fetch_array calls will have an entry for that field containing an
entry string) and then back again to null. I've just tried it on my machine
and it works a treat.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.dialsolutions.com
http://www.dtonline.org
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
