Hello,
I try to create the table 2010craftitems with this code, I run the page on the server but the table is not being created any ideas why?
mysql_connect("servert", "dbname", "password") or die(mysql_error());
mysql_select_db("dbname") or die(mysql_error());
mysql_query("CREATE TABLE 2010craftitems (itemnum int(11) NOT NULL
auto_increment,
description varchar(255) NOT NULL,
size varchar(50) default NULL,
thumbnail varchar(100)
default 'blank_thb.jpg',
highbid varchar(10) default
NULL,
category varchar(100) default NULL,
pattern
varchar(100) default NULL,
colors varchar(255) default
NULL,
madeby varchar(255) default NULL,
quiltedby
varchar(255) default NULL,
tiedby varchar(255) default
NULL,
donatedby varchar(255) default NULL,
largegif
varchar(100) default 'blank_lg.jpg',
thumb_width int(11)
default '130',
thumb_height int(11) default '110',
gif_width int(11) default '467',
gif_height int(11)
default '390',
PRIMARY KEY (itemnum)
)
ENGINE=MyISAM DEFAULT CHARSET=utf8
)");
Print "The table has been created";
?>
ENGINE=MyISAM DEFAULT CHARSET=utf8
)");
There shouldn't be a closing parenthesis after the CHARSET.
ENGINE=MyISAM DEFAULT CHARSET=utf8" );