I try to dump this in to MySQL...

CREATE TABLE affiliates (
  affID int(3)  DEFAULT '' NOT NULL auto_increment,
  refid varchar(30)  DEFAULT '' NOT NULL ,
  pass varchar(20)  DEFAULT '' NOT NULL ,
  company varchar(100)  DEFAULT '' NOT NULL ,
  title varchar(5)  DEFAULT '' NOT NULL ,
  firstname varchar(40)  DEFAULT '' NOT NULL ,
  lastname varchar(40)  DEFAULT '' NOT NULL ,
  website varchar(100)  DEFAULT '' NOT NULL ,
  email varchar(100)  DEFAULT '' NOT NULL ,
  payableto varchar(100)  DEFAULT '' NOT NULL ,
  street varchar(100)  DEFAULT '' NOT NULL ,
  town varchar(100)  DEFAULT '' NOT NULL ,
  county varchar(100)  DEFAULT '' NOT NULL ,
  postcode varchar(20)  DEFAULT '' NOT NULL ,
  country varchar(100)  DEFAULT '' NOT NULL ,
  phone varchar(30)  DEFAULT '' NOT NULL ,
  fax varchar(30)  DEFAULT '' NOT NULL ,
  date varchar(40)  DEFAULT '' NOT NULL ,
  PRIMARY KEY (affID)
);
 
INSERT  INTO affiliates  VALUES('1','testAff','testAff','testAff','Mr','testAff','testAff','testAff','','testAff','testAff','testAff','testAff','testAff','US','testAff','testAff','');
INSERT  INTO affiliates  VALUES('2','testAff1','testAff1','testAff1','Mr','testAff','testAff','','tester@hotmail.com','testAff','testAff','testAff','testAff','testAff','US','testAff','testAff','');

And it says that the first line, "affID int(3) DEFAULT '' NOT NULL auto_increment,"

is not a valid way to write that string of text, rejecting my entry.

I'm a beginner, and have no way of knowing why this would be so: Perhaps you can tell me?

Lose the default value defined in the primary field (affID). This is an auto incremented field, there should not be a default value defined.

I always create my DB tables using PHPMyAdmin and then copy the code. Very easy and reduces errors.

Thanks, I will try that

I tried putting this into my database:

affID int(3) '' NOT NULL auto_increment,

still got an error.

I've just heard of PHPmyAdmin, so I will be looking into getting that program as well.

i've been inserting all my tables manually for a little while now, so it'd be cool to actually use an editor to let me know when I mess up.