[SOLVED] Insert not working.

[daveoffy]

I have the following code and I am just missing something stupid. I looked at it many times and than thought I would come here to get an answer.

 

$insert = "INSERT INTO Sell(newstatus, buyer) VALUES('$newstatus', '$buyerusername') WHERE sell_id = '".$sellid."'";
$insertresult = mysql_query($insert);

[rhodesa]

Step one whenever you have a problem, is to use mysql_error() to see what the error is:

$insert = "INSERT INTO Sell(newstatus, buyer) VALUES('$newstatus', '$buyerusername') WHERE sell_id = '".$sellid."'";
$insertresult = mysql_query($insert) or die(mysql_error());

 

you will find that there is no WHERE clause for an INSERT statement. what are you trying to accomplish? Are you looking to UPDATE a record?