$con = mysql_connect ("localhost", "myusername", "mypassword"); if(!$con) { die("because:O"); } mysql_select_db("hellgate_item", $con); $sql = "CREATE TABLE weapons ( wepID int NOT NULL AUTO_INCREMENT, PRIMARY KEY(wepID), name varchar(20); description varcar(200); base varchar(20); type varchar(20); img varchar(120); mods varchar(120); quality varchar(20); screen1 varchar(120); screen2 varchar(120); misc1 varchar(20); misc2 varchar(20); misc3 varchar(20); misc4 varchar(20); misc5 varchar(20); )"; mysql_query($sql,$con); mysql_query("INSERT INTO weapons (name, description, base,type,img,mods,quality,screen1,screen2) VALUES ('junk','something','somethingasbase','type','img',mods','quality','screen1',screen2')"); mysql_close($con); echo "Completed!"; ?>