include ("auth.inc.php3");?>
echo "";
$i=0;
$oldname="oldname$i";
$qr="ALTER TABLE $tablename CHANGE $$oldname ";
$vname="name$i";
$vtype="type$i";
$vlen="len$i";
$vnull="null$i";
$vunique="unique$i";
$vkey="key$i";
$vkeyspec="keyspec$i";
$vdefault="default$i";
$vauto_increment="auto_increment$i";
$qr=$qr+"$$vname ";
if ($$vlen!=""):
$qr=$qr+" $$vtype($$vlen)";
else:
$qr=$qr+" $$vtype";
endif;
$qr=$qr+" $$vnull ";
if ($$vdefault!=""):
$qr=$qr+" DEFAULT '$$vdefault'";
endif;
$qr=$qr+" $$vauto_increment $$vkey $$vkeyspec ";
$i++;
if($i<$campi):
$qr=$qr+",";
endif;
echo "
";
$rs=@mysql($dbname,"$qr");
include("report.inc.php3");
mysql_close();
echo "
go on ";
echo "";
?>