Help! Duplicate Entries

[artisticre]

OK I still am getting duplicate entries

mysql_query("INSERT INTO Type (type) VALUES ('$type')") or die(mysql_error());
$typeid=mysql_insert_id();
mysql_query("INSERT INTO Varietal (varietal) VALUES ('$varietal')") or die(mysql_error());
$varietalid=mysql_insert_id();
mysql_query("INSERT INTO Label (label) VALUES ('$label')") or die(mysql_error());
$labelid=mysql_insert_id();

mysql_query("INSERT INTO Wine ( varietalid, typeid, labelid) VALUES ($varietalid, $typeid, $labelid)") or die(mysql_error());

CREATE TABLE Wine (
WineID int(4) NOT NULL auto_increment,
labelid int(4) NOT NULL default '0',
varietalid int(4) NOT NULL default '0',
typeid int(4) NOT NULL default '0',
PRIMARY KEY (WineID)
) TYPE=MyISAM;

CREATE TABLE Varietal (
varietalid int(4) NOT NULL auto_increment,
varietal varchar(255) NOT NULL default '',
PRIMARY KEY (varietalid)
) TYPE=MyISAM;

CREATE TABLE Type (
typeid int(4) NOT NULL auto_increment,
type varchar(255) NOT NULL default '',
PRIMARY KEY (typeid)
) TYPE=MyISAM;

CREATE TABLE Producer (
producerid int(4) NOT NULL auto_increment,
producer varchar(100) NOT NULL default '',
PRIMARY KEY (producerid)
) TYPE=MyISAM;

CREATE TABLE Label (
labelid int(4) NOT NULL auto_increment,
label varchar(100) NOT NULL default '',
PRIMARY KEY (labelid)
) TYPE=MyISAM;
😕

[dalecosp]

I'm still getting duplicate entries

Where?

Generally, the SQL only needs "Insert into Labels Values" --- I wonder if "Insert into Labels (labels) Values" is part of your trouble, which you didn't specifcally identify to those of us who didn't see (what I assume was) a previous post.

[artisticre]

Basically the code works but in all tables I am getting duplicate entries. Instead of it entering the table once, I get two of the same entry