Adding New Collumns
Posted: Mon Dec 29, 2003 9:18 am
I get this error :
Warning: sqlite_query(): near "ALTER": syntax error in c:\ftp\users\straterra\eck\cgi-bin\newcollumn.php on line 7
When I use this code :
Can anyone tell me what I did wrong?
Warning: sqlite_query(): near "ALTER": syntax error in c:\ftp\users\straterra\eck\cgi-bin\newcollumn.php on line 7
When I use this code :
Code: Select all
<?php
$dbname = 'eckbios';
if ($db = sqlite_open($dbname, 0666, $sqliteerror)){
sqlite_query($db, "ALTER TABLE clanprofile
ADD bgcolor VARCHAR (30),
ADD textcolor VARCHAR (30)
");
} else {
die ($sqliteerror);
}
?>