Newbie to PHP inserting

[artisticre]

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;

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

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

$InsertSQL = "INSERT INTO Producers(producersID, varietaltypeID, ratingID, availableID) VALUES ($producersID, varietaltypeID, ratingID, availableID)";
$InsertResult = mysql_query($InsertSQL) or die(mysql_error());

echo "Information Entered";

Here are my tables and code to insert. I keep getting a duplicate key error. I am a newbie at this. Can someone lend a hand?

thanks

[OhLordy]

It's generally safer to make your primary key autoincrementing and then don't set it on insert. The problem you are having that you are trying to insert two rows with the same primary key which is not allowed as the primary key must be unique.
HTH
Rob

[artisticre]

I don't follow. Can you show an example?

thanks

[artisticre]

Ok I got it to write to the database but it still isn't writing the ID's in the Producers table...and it is duping the entry

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