Global Changes With Loop To Allow Nulls In A Table...

[revDAVE <Cool@xxxxxxxxxxxxxxxx>]

Hi Folks,

Newbie question....

I have a mysql table with 100 fields, currently all do not allow nulls.
Rather than hand typing in phpMyAdmin, I would like a way to loop through
all fields and update them to allow nulls....

My Beginning attempt needs help...


$i = 1;
while ($i <= 100):

// how do I word this to just change whatever field we are on to allow
nulls?

$sql = 'ALTER TABLE `mytable` ?*update*? `'.$???WhatEverField??[$i].'`
?ALLOWNULL?;';

//mysql_query($sql);

$result = mysql_query($sql) or die("<br /><br /> Could not renumber dB $sql
<br /><br />" . mysql_error());


    $i++;
endwhile;


Thanks in advance



--
Thanks - RevDave
Cool @ hosting4days . com
[db-lists 09]




-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php