Hi,
I've installed everything as per instructions but when I come to run the queries I get an error. Any help is appreciated.
PHP Code:
DROP TABLE IF EXISTS affiliates;
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
sitename varchar(50) NOT NULL,
siteurl varchar(250) NOT NULL,
sitedesc mediumtext NOT NULL,
buttonurl varchar(150) NOT NULL,
type tinyint(4) NOT NULL,
email varchar(250) NOT NULL,
clicksout int(20) NOT NULL,
clicksin int(20) NOT NULL,
active tinyint(4) NOT NULL,
totalrating bigint(20) NOT NULL,
totalvotes bigint(20) NOT NULL,
approved tinyint(4) NOT NULL,
PRIMARY KEY (affiliate_id),
KEY sitename (sitename),
KEY siteurl (siteurl),
KEY email (email)
);
PHP Code:
An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL auto_increment,
' at line 1