MySQL Error querying from PHP: IF EXISTS

Question

I have this PHP Code with Query to mysql database:

$query2 = "IF( EXISTS (SELECT * FROM shipcargo WHERE shipid='$shipid' AND item='$item' AND price='$price')) 
    BEGIN
    UPDATE shipcargo SET amount = amount+'$amount' WHERE shipid='$shipid' AND item='$item' AND price='$price'
    END
    ELSE
    BEGIN
    INSERT INTO shipcargo (shipid, item, amount, price) VALUES('$shipid', '$item', '$amount', '$price')
    END";
    mysql_query($query2) or die(mysql_error());

The Error Returned is:

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 shipcargo WHERE shipid='11' AND item='WheatBastard' AN' at line 1

PHP does not trigger SQL errors. You have to check what exactly $query2 contains and see if it's valid SQL code. — Álvaro González
– Álvaro González, Commented Mar 5, 2012 at 11:05

Luca Davanzo · Accepted Answer · 2012-03-05 11:03:40Z

1

syntax is wrong! Take a look at http://dev.mysql.com/doc/refman/5.0/en/exists-and-not-exists-subqueries.html

answered Mar 5, 2012 at 11:03

Luca Davanzo

21.6k15 gold badges124 silver badges152 bronze badges

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

Comments

Liath · Accepted Answer · 2012-03-05 11:00:41Z

0

I believe it's

IF EXISTS (SELECT * FROM

Rather than

IF (EXISTS ( SELECT

You don't need a bracket with the IF statement

answered Mar 5, 2012 at 11:00

Liath

10.2k10 gold badges55 silver badges82 bronze badges

Collectives™ on Stack Overflow

MySQL Error querying from PHP: IF EXISTS

2 Answers 2

Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Related