SQL Query Error

Question

What is wrong with this Query?

INSERT INTO Registration 
  (`Status`, `String`) 
VALUES 
  ('Confirmed', '0') 
WHERE `String` = '". mysql_real_escape_string($user) ."'

1A:

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

Phil · Accepted Answer · 2010-10-21 21:32:38Z

5

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

answered Oct 21, 2010 at 21:32

Phil

166k25 gold badges265 silver badges269 bronze badges

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

1 Comment

Oh, that makes sense! So, I would need to to this [see 1A on original post]?

OMG Ponies · Accepted Answer · 2010-10-21 21:47:07Z

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:

answered Oct 21, 2010 at 21:47

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

PureForm · Accepted Answer · 2010-10-21 21:36:25Z

1

answered Oct 21, 2010 at 21:36

PureForm

1,0038 silver badges15 bronze badges