RE: [PHP-DB] my sql text query

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'm still trying to figure out what any of this has to do with an index? Do you have an index on this description field? Cal http://www.calevans.com -----Original Message----- From: Phil Driscoll [mailto:phil@dialsolutions.co.uk] Sent: Friday, March 09, 2001 7:59 AM To: Steve Brett; php-db@lists.php.net Subject: Re: [PHP-DB] my sql text query 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.dialsolutions.com http://www.dtonline.org -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net For additional commands, e-mail: php-db-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net