[SOLVED] mysql query

[ShaolinF]

Hi Guys,

 

Keep getting Parse error: syntax error, unexpected T_VARIABLE for the following

 

mysql_query("INSERT INTO purchase (pp_txn_id, pp_payment_date, pp_pending_reason) 
VALUES ('".$_POST['txn_id']."', '".$_POST['payment_date']."', '".$_POST['pending_reason']."') 
WHERE purchaseid = '"$_POST['invoice']"' ") or die ($error = mysql());

 

The error is pointing to the third line of code.

[ShaolinF]

Man, can't edit it. I fixed it. But here is the new message I get:

 

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 purchaseid = ''' at line 3

[revraz]

Post the new query, you have a problem before the WHERE

[ShaolinF]

mysql_query("INSERT INTO purchase (pp_txn_id, pp_payment_date, pp_pending_reason) 
VALUES ('".$_POST['txn_id']."', '".$_POST['payment_date']."', '".$_POST['pending_reason']."') 
WHERE purchaseid = $_POST['invoice'] ") or die (mysql_error());

[revraz]

echo the query to see what it actually looks like

[ShaolinF]

This is what is says:

 

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 purchaseid = 1' at line 3

 

Echo doesn't work..

[revraz]

You are doing a INSERT and using WHERE, you can't do that.

 

INSERT inserts a new Row.

 

If you have an existing Row, use the UPDATE function.

[chum]

rofl, yea...you can't use where with insert..

[ShaolinF]

hah, thanks. How could I have missed that one, I need to get some sleep!