SQL Error

artisticre

Here is the error I get:

You have an error in your SQL syntax near '$producer', '$producerdesc')") or die(mysql_error()); ')' at line 1

Here Is My code:

mysql_query("INSERT INTO Producer (producer, producerdesc) VALUES ('$producer', '$producerdesc')")
or die(mysql_error());
$producerid=mysql_insert_id();

Here Is My Table:

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

Here is how I insert it:

Anyone have any suggestions?

stolzyboy

$query = "INSERT INTO Producer (producer, producerdesc) VALUES ('$producer', '$producerdesc');";

$result = mysql_query($query) or die(mysql_error());

artisticre

Thanks, How would you do this then:

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 Producer (producer, producerdesc) VALUES ('$producer', '$producerdesc')")
or die(mysql_error());
$producerid=mysql_insert_id();

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

Form stuff here

stolzyboy

try this, there may be parse errors, didn't check it, but you should get the idea, you can also try seperating the statements by a semicolon in one query, but that probably wouldn't work since you want the id with mysql_insert_id for each query, lemme know

<?
$query1 = "INSERT INTO Type (type) VALUES ('$type');";
$result1 = mysql_query($query1) or die(mysql_error());
$typeid = mysql_insert_id();

$query2 = "INSERT INTO Varietal (varietal) VALUES ('$varietal');";
$result2 = mysql_query($query2) or die(mysql_error());
$varietalid = mysql_insert_id();

$query3 = "INSERT INTO Label (label) VALUES ('$label');";
$result3 = mysql_query($query3) or die(mysql_error());
$labelid = mysql_insert_id();

$query4 = "INSERT INTO Producer (producer, producerdesc) VALUES ('$producer', '$producerdesc');";
$result4 = mysql_query($query4) or die(mysql_error());
$producerid = mysql_insert_id();

$query5 = "INSERT INTO Wine (varietalid, typeid, labelid, producerid) VALUES ($varietalid, $typeid, $labelid, $producerid);";
$result5 = mysql_query($query5) or die(mysql_error());
?>

artisticre

OK I figured out what I got the error message. My text I am inputting has formatting symbols such as periods, commas, etc. My question is how do I code it so the database will accept them?

Weedpacket

[man]mysql_escape_string[/man]

stolzyboy

there should be no problem with commas and such as long as you are inserting into the database with ticks(single quotes)

$query = "insert into table (field1, field2) values ('$var1', '$var2');"; // notice ticks around the variables

$result = mysql_query($query) or die(mysql_error());