Sql Query Error

What is wrong with this Query? INSERT INTO Registration (`Status`, `String`) VALUES ('Confirmed', '0') WHERE `String` = ''. mysql_real_escape_string($user) .'' 1A: UPDATE

Solution 1:

You don't specify a WHERE clause on an INSERT query, only UPDATE.

Solution 2:

Use:

UPDATE Registration 
   SET `Status` = 'Confirmed', 
       `String` = '0' WHERE `String` = '". mysql_real_escape_string($user) ."'

INSERT is for brand-new records; if you are change values associated to an existing value -- you need to use UPDATE.

Reference:

• UPDATE
• INSERT

Solution 3:

It might be worth combing over this page: http://dev.mysql.com/doc/refman/5.1/en/insert.html