PHP - Update and set multiple variables with different WHERE [duplicate]

Question

Need to update different values with different WHERE.

$facebook = $_POST["facebook"];
$twitter = $_POST["twitter"];
$instagram = $_POST["instagram"];

$sql = "UPDATE footer SET link='$facebook' WHERE name='Facebook' AND SET link='$twitter' WHERE name='Twitter' AND SET link='$instagram' WHERE name='Instagram'";

$sql = "UPDATE footer SET link='$facebook' WHERE name='Facebook' AND SET link='$twitter' WHERE name='Twitter' AND SET link='$instagram' WHERE name='Instagram'"; is not working — John Doe
– John Doe, Commented Mar 7, 2016 at 11:19
Why don't do 3 queries? otherwise try something like this: stackoverflow.com/a/20255203/5368495 — Charles
– Charles, Commented Mar 7, 2016 at 11:19

Funk Forty Niner · Accepted Answer · 2016-03-07 13:09:50Z

0

You can do this with case expression:

$sql = "UPDATE footer SET link = case when name='Facebook' then '$facebook'
                                      when name='Twitter' then '$twitter' 
                                      when name='Instagram' then '$instagram'
                                  end

edited Mar 7, 2016 at 13:09

Funk Forty Niner

74.2k14 gold badges71 silver badges146 bronze badges

answered Mar 7, 2016 at 11:19

sagi

40.6k7 gold badges66 silver badges87 bronze badges

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

4 Comments

John Doe Over a year ago

Working perfectly! Thank you.

Funk Forty Niner Over a year ago

This would have been a better answer if the errors that the OP made in their syntax were explained. As in UPDATE only uses one SET and one WHERE clause. dev.mysql.com/doc/refman/5.7/en/update.html

Funk Forty Niner Over a year ago

@JohnDoe You're welcome John.

sagi Over a year ago

@Fred-ii- You're right, was in a hurry:) usually I'm posting an explanation

Collectives™ on Stack Overflow

PHP - Update and set multiple variables with different WHERE [duplicate]

1 Answer 1

4 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Linked

Related