ok it says
Code:
Run this query:
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)
);
i do and i get this error
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. Check the manual that corresponds to your MySQL server version for the right syntax to use near ';
CREATE TABLE affiliates (
affiliate_id int(10) NOT NULL a
i have no idea what i did wrong? i did everything right but the SQL queries
thanks in advanced