SQL Query IF EXISTS not working

Question

I have the following sql query that I want to run with PHP. Why doesn't it work?

IF EXISTS(SELECT * FROM content WHERE site_id ='". $id ."') BEGIN
UPDATE content SET
titel = '". htmlentities($connect->real_escape_string($data[0])) ."',
content = '". htmlentities($connect->real_escape_string($data[1])) ."'
WHERE site_id ='". $id ."'
END
ELSE
BEGIN
INSERT INTO content (site_id, titel, content)
VALUES (
'". $id ."',
'". htmlentities($connect->real_escape_string($data[0])) ."',
'". htmlentities($connect->real_escape_string($data[1])) ."'
)
END

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 'IF EXISTS(SELECT * FROM content WHERE site_id ='1') BEGIN UPDATE content SET tit' at line 1

Why not use INSERT .. ON DUPLICATE KEY UPDATE

Saty
– Saty

2015-12-09 11:12:42 +00:00
Commented Dec 9, 2015 at 11:12 — Saty
– Saty, Commented Dec 9, 2015 at 11:12
Edit your question with error details.

Partha Sarathi Ghosh
– Partha Sarathi Ghosh

2015-12-09 11:18:49 +00:00
Commented Dec 9, 2015 at 11:18 — Partha Sarathi Ghosh
– Partha Sarathi Ghosh, Commented Dec 9, 2015 at 11:18

Richard St-Cyr · Accepted Answer · 2015-12-09 13:34:44Z

2

I suppose that site_id is a unique key in your table. Use the solution proposed by @Saty

INSERT INTO content (site_id, titel, content)
VALUES (
  '". $id ."',
  '". htmlentities($connect->real_escape_string($data[0])) ."',
  '". htmlentities($connect->real_escape_string($data[1])) ."'
)
ON DUPLICATE UPDATE 
  titel = '". htmlentities($connect->real_escape_string($data[0])) ."',
  content = '". htmlentities($connect->real_escape_string($data[1])) ."';

answered Dec 9, 2015 at 13:34

Richard St-Cyr

9951 gold badge8 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

SQL Query IF EXISTS not working

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related