I ran this simple code and it turned up a MySQL error and I have utterly no idea why. I am 100% sure the variables have content in them, but I even tried removing them and puting dummy data like "hi" etc, and still had the problem so its not that.

PHP Code:

mysql_query("INSERT INTO Links (bid) VALUES('$payment_amount') WHERE url='$item_number'") 
or die(mysql_error()); 


I even went into phpMyAdmin and ran just the SQL:

PHP Code:

INSERT INTO Links (bid) VALUES('$payment_amount') WHERE url='$item_number' 


It errored there as well. I am totally confused! Am I doing something stupid?

Ok, yeah I was doing something stupid figured it out though. There isn't such thing as a WHERE in an insert, you have to update. Here is what I did instead and it worked:

PHP Code:

mysql_query("UPDATE Links SET bid = '$payment_amount' WHERE url = '$item_number'") or die(mysql_error()); 


PHP Code:

UPDATE `Links` SET `bid` = '$payment_amount' WHERE `url` = '$item_number';