Duplicate Error
Posted: Tue Dec 16, 2003 8:21 pm
I get this error : Warning: sqlite_query(): duplicate column name: firstname in c:\ftp\users\straterra\eck\cgi-bin\tablemake1.php on line 22 : when I try to run this code
Please help!
Code: Select all
<?php
$dbname = 'eckbios';
if ($db = sqlite_open($dbname, 0666, $sqliteerror)){
$createtable = sqlite_query($db, "create table clanprofile
(firstname varchar(15),
lastname varchar(15),
middleinit varchar(5),
birthyear varchar(15),
firstname varchar(15),
socomname varchar(40),
socommap varchar(40),
sealswep varchar(15),
terrwep varchar(15),
website varchar(100),
hometown varchar(75),
picture varchar(150),
gender varchar(15),
birthday varchar(100),
occupation varchar(75),
bands varchar(200),
tvshows varchar(200),
movies varchar(200))");
} else {
die ($sqliteerror);
}
?>