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

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]