[maurier]

I have run SQL-query using phpmyadmin getting error: my site vbRc4 help me please !

CREATE TABLE " . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_increment,
name varchar(50) NOT NULL default '',
description varchar(250) NOT NULL default '',
icon_url varchar(250) NOT NULL default '',
PRIMARY KEY (awardid)
) TYPE=MyISAM;

MySQL said:


You have an error in your SQL syntax near '" . TABLE_PREFIX . "award (
awardid smallint(5) unsigned NOT NULL auto_incre' at line 1

CREATE TABLE " . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
PRIMARY KEY (userid)
) TYPE=MyISAM;

MySQL said:


You have an error in your SQL syntax near '" . TABLE_PREFIX . "useraward (
userid int(10) NOT NULL auto_increment,
' at line 1