[LEAD_WEIGHT]

https://vborg.vbsupport.ru/showpost....&postcount=210

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 au

Is this one query or many cause I copy & paste & get that 1064 error so how do I do this.

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)
);

Got it this is one query

DROP TABLE IF EXISTS affiliates;

and this is the next query [ after each ( ; ) is a query ]

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)
);

credits for help MarcoH64 at vb.com & I guess same guy here :ermm:




One more thing is I am surprise u do not have a paypal donate thing cause of the time u spent on this. :nervous: