php getting insert errors

Question

I'm getting insert into mysql errors, my code is involved with array, so this part of code is not using array but the codes is comes with array for other features to use.

when I tried to insert new records in mysql , the insert code is giving me errors...

the errors said..

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''product_name') VALUES ('Array' where product_id='3246')' at line 1 ....

this for ....

$query="INSERT INTO product ('product_name') VALUES ('".$product_name."' where product_id='$product_id[$i]') ";

and then remove ' ' ... like this...

$query="INSERT INTO product (product_name) VALUES ('".$product_name."' where product_id='$product_id[$i]') ";

the new errors said ..

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where product_id='3246')' at line 1

and then i removed ' ' where it said where product_id = .... like this.

$query="INSERT INTO product (product_name) VALUES ('".$product_name."' where product_id=$product_id[$i]) ";

and now new errors ...

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where product_id=3246)' at line 1

what did i do wrong and how to solve that?

AM

Why do you concatenate $product_name but not $product_id[$i]? — John Conde
– John Conde, Commented Apr 8, 2014 at 14:13
Why would you have a WHERE condition in your INSERT statement? — domdomcodecode
– domdomcodecode, Commented Apr 8, 2014 at 14:17

gbestard · Accepted Answer · 2014-04-08 14:16:04Z

1

Like you said your sql syntax is wrong.

You should use

$query="INSERT INTO product (product_name,product_id) VALUES ('$product_name', '$product_id[$i]') ";

to insert a new record

or

$query = "UPDATE product SET product_name = '$product_name' WHERE product_id='$product_id[$id]'";

to update one already existing

edited Apr 8, 2014 at 14:16

answered Apr 8, 2014 at 14:14

gbestard

1,17713 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

ponciste Over a year ago

there's a ' more before $product_id[$id]

user3417953 Over a year ago

I have tried both code from user name gbestard is not working due to the first insert code said "Duplicate entry '3246' for key 'PRIMARY'" the second one is giving me same old errors. so is not working any other idea! Also .. for user name Token, my case i relate to copy the records and insert as new records. so this must be using Insert instead of UPDATE.

gbestard Over a year ago

If you just want the modufy an existing record the first query will fail, but the second should work, what error do you get?

domdomcodecode · Accepted Answer · 2014-04-08 14:19:12Z

0

You can't be having a WHERE condition in your INSERT statement. Maybe you're trying to UPDATE existing records instead?

$query="UPDATE product SET product_name = '".$product_name."'
WHERE product_id=$product_id[$i]";

answered Apr 8, 2014 at 14:19

domdomcodecode

2,4734 gold badges21 silver badges27 bronze badges

5 Comments

user3417953 Over a year ago

So i changed insert code like this ... $query="INSERT INTO product (product_name, product_category) VALUES ('".$product_name.",".$product_category."') "; but the errors said Column count doesn't match value count at row 1 ..... does this error mean the column name are not match is that correct!

domdomcodecode Over a year ago

name and category are strings, so you need to add some single quotes to wrap around them. You're using variables to hold the names, but when you're constructing the SQL queries, they also need text wrapped in quotes.

user3417953 Over a year ago

you mean like this ... $query="INSERT INTO product (product_name) VALUES ('.$product_name[i].') "; is where i put '.$product_name[i].' is this correct!

domdomcodecode Over a year ago

Yeah, I think you get the picture :)

domdomcodecode Over a year ago

You need to be more specific, plus you've already accepted an answer. What's the issue now?

Collectives™ on Stack Overflow

php getting insert errors

2 Answers 2

3 Comments

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related