PDA

View Full Version : parse error


tcjay
12-6-01, 10:17 PM
Can anyone spsot a parse error. I have been racking my brain for errors trying to identify the reason why I am receiving a parse on line 2?

TIA

Tom

#!/usr/local/bin/php
<?php
$connection = mysql_connect("neptune, "needlept", "XXXXX") or die("Couldn't connect.");
$db = @mysql_select_db("needlept", $connection) or die("Couldn't select database.");

$sql = CREATE TABLE listdesign (
id tinyint(4) NOT NULL auto_increment,
sAlignment varchar(6) NOT NULL default '',
sWidth int(11) NOT NULL default '0',
sWidthMeasure varchar(7) NOT NULL default '',
sBorderSize int(11) NOT NULL default '0',
sBorderColor varchar(6) NOT NULL default '',
hTitle varchar(30) NOT NULL default '',
hBold char(1) NOT NULL default '',
hAlignment varchar(6) NOT NULL default '',
hBackColor varchar(6) NOT NULL default '',
hFont varchar(40) NOT NULL default '',
hFontColor varchar(6) NOT NULL default '',
hFontSize tinyint(4) NOT NULL default '0',
bAlignment varchar(6) NOT NULL default '',
bBackColor varchar(6) NOT NULL default '',
bBold char(1) NOT NULL default '',
bText varchar(200) NOT NULL default '',
bFont varchar(40) NOT NULL default '',
bFontColor varchar(6) NOT NULL default '',
bFontSize tinyint(4) NOT NULL default '0',
fMaxChar smallint(6) NOT NULL default '0',
fFieldLength smallint(6) NOT NULL default '0',
fButtonText varchar(15) NOT NULL default '',
PRIMARY KEY (id),
UNIQUE KEY id (id),
KEY id_2 (id))";

$result = mysql_query($sql,$connection) or die("Couldn't execute query.");
if ($result) {
$msg = "<P>$table_name has been created!</P>";
}
?>