Ok I got it to write to the database but it still isn't writing the ID's in the Producers table
$ProducerSQL = "INSERT INTO Producers (producers, description, label, picture) VALUES ('$producers', '$description', '$label', '$picture')";
$ProducerResult = mysql_query($ProducerSQL) or die(mysql_error());
$producersID = mysql_insert_id();
$varietaltypeID = mysql_insert_id();
$ratingID = mysql_insert_id();
$availableID = mysql_insert_id();
$InsertSQL = "INSERT INTO Producers(varietaltypeID, ratingID, availableID) VALUES ( varietaltypeID, ratingID, availableID)";
$InsertResult = mysql_query($InsertSQL) or die(mysql_error());
$AvailableSQL = "INSERT INTO Available (availableID, available, region, country) VALUES ('$availableID', '$available', '$region', '$country')";
$AvailableResult = mysql_query($AvailableSQL) or die(mysql_error());
$RatingSQL = "INSERT INTO Rating (ratingID, rating, portfolio, volume, caseprice, bottleprice) VALUES ('$ratingID', '$rating', '$portfolio', '$volume', '$caseprice', '$bottleprice')";
$RatingResult = mysql_query($RatingSQL) or die(mysql_error());
$VarietalTypeSQL = "INSERT INTO VarietalType (varietaltypeID, varietal, type, vintage) VALUES ('$varietaltypeID', '$varietal', '$type', '$vintage')";
$VarietalTypeResult = mysql_query($VarietalTypeSQL) or die(mysql_error());
CREATE TABLE Available (
availableID tinyint(4) NOT NULL default '0',
available varchar(50) NOT NULL default '',
region varchar(50) NOT NULL default '',
country varchar(20) NOT NULL default '',
PRIMARY KEY (availableID)
) TYPE=MyISAM;
CREATE TABLE Producers (
producersID tinyint(4) NOT NULL auto_increment,
producers varchar(50) NOT NULL default '',
description longtext NOT NULL,
label varchar(50) NOT NULL default '',
picture longtext NOT NULL,
varietaltypeID tinyint(4) NOT NULL default '0',
ratingID tinyint(4) NOT NULL default '0',
availableID tinyint(4) NOT NULL default '0',
PRIMARY KEY (producersID)
) TYPE=MyISAM;
CREATE TABLE Rating (
ratingID tinyint(4) NOT NULL default '0',
rating varchar(50) NOT NULL default '',
portfolio varchar(50) NOT NULL default '',
volume varchar(20) NOT NULL default '',
caseprice int(20) NOT NULL default '0',
bottleprice int(20) NOT NULL default '0',
PRIMARY KEY (ratingID)
) TYPE=MyISAM;
CREATE TABLE VarietalType (
varietaltypeID tinyint(4) NOT NULL default '0',
varietal varchar(50) NOT NULL default '',
type varchar(50) NOT NULL default '',
vintage varchar(50) NOT NULL default '',
PRIMARY KEY (varietaltypeID)
) TYPE=MyISAM;
