if else mysql syntax

Question

Can anybody help me in this syntax? I don't know what wrong am I doing!

When I try to execute this code:

IF EXISTS(SELECT * FROM user WHERE user_username = '$user_username') 
THEN
UPDATE user SET user_name='$name',user_profession='$profession',user_address='$address',user_avatar='$NewImageName'
ELSE 
INSERT INTO user (user_name,user_profession,user_address,user_avatar) VALUES ('$name','$profession','$address','$NewImageName';

I get the following error:

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 user WHERE user_username = '111') THEN UPDATE user SE' at line 1

I don't know what is wrong with this code!

@tsHunter yes he does. dev.mysql.com/doc/refman/5.0/en/if.html — Félix Adriyel Gagnon-Grenier
– Félix Adriyel Gagnon-Grenier, Commented Jun 20, 2014 at 18:38
I was trying to UPDATE the table when the IF EXISTS part is TRUE. Else, I wanted to INSERT into the table. — Nirmalya Ghosh
– Nirmalya Ghosh, Commented Jun 21, 2014 at 1:35

funkhouserben · Accepted Answer · 2014-06-20 18:39:54Z

1

Have you tried adding an END IF after the INSERT INTO... statement?

answered Jun 20, 2014 at 18:39

funkhouserben

357 bronze badges

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

3 Comments

funkhouserben Over a year ago

There also needs to be a ) before the ; at the end of your VALUES statement.

funkhouserben Over a year ago

@NirmalyaGhosh Great! If this answered the question for you would you mind accepting it as the answer? Thanks.

funkhouserben Over a year ago

@NirmalyaGhosh I see it now. Sorry about that.

echo_Me · Accepted Answer · 2014-06-20 18:46:45Z

0

you need ON DUPLICATE KEY

INSERT INTO user (user_name,user_profession,user_address,user_avatar)
VALUES ('$name','$profession','$address','$NewImageName'
   ON DUPLICATE KEY
UPDATE user SET user_name='$name',
                user_profession='$profession',
                user_address='$address',
                user_avatar='$NewImageName'

you must have column user_name as UNIQUE

if its not unique do this

ALTER IGNORE TABLE user ADD UNIQUE (user_name);

edited Jun 20, 2014 at 18:46

answered Jun 20, 2014 at 18:41

echo_Me

37.2k5 gold badges62 silver badges81 bronze badges

1 Comment

Félix Adriyel Gagnon-Grenier Over a year ago

he doesn't need an ON DUPLICATE KEY, he needs a working IF statement. Your proposing another solution, but this is not an answer, is it?

Nirmalya Ghosh · Accepted Answer · 2014-06-21 02:50:40Z

0

The following piece of code did the trick for me:

$result = mysql_query("SELECT * FROM user WHERE user_username = '$user_username'");
if( mysql_num_rows($result) > 0) {
    mysql_query("UPDATE user SET user_name='$name',user_profession='$profession',user_address='$address',user_avatar='$NewImageName' WHERE user_username = '$user_username'");
}
else
{
    mysql_query("INSERT INTO user (user_name,user_profession,user_address,user_avatar) VALUES ('$name','$profession','$address','$NewImageName') WHERE user_username = '$user_username'");
}

answered Jun 21, 2014 at 2:50

Nirmalya Ghosh

2,5603 gold badges20 silver badges34 bronze badges

Collectives™ on Stack Overflow

if else mysql syntax

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

3 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related