>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 h
Cal
http://www.calevans.com
-Original Message-
From: Phil Driscoll [mailto:[EMAIL PROTECTED]]
Sent: Friday, March 09, 2001 7:59 AM
To: Steve Brett; [EMAIL PROTECTED]
Subject: Re: [PHP-DB] my sql text query
Good heavens, another PHP developer in Leeds:)
I think (I haven't tried t
Good heavens, another PHP developer in Leeds:)
I think (I haven't tried this!) you could change the field type to
not-null - then your array should get populated with empty strings for any
records where this field is not set.
Cheers
--
Phil Driscoll
Dial Solutions
+44 (0)113 294 5112
http://www.
hi,
i'm currently writing an e-commerse site using php for the shopping cart
stuff and mysql as the db.
i've got a text filed of type text that holds descriptions for the items but
only need to display it if a description exists, so many of the fields are
null. the field was added to the table w
