PHP - Update and set multiple variables with different WHERE

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, Mar 07 '16 at 11:19
Why don't do 3 queries? otherwise try something like this: http://stackoverflow.com/a/20255203/5368495 — Charles, Mar 07 '16 at 11:19

score 0 · Accepted Answer · edited Mar 07 '16 at 13:09

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 07 '16 at 13:09

Funk Forty Niner

74,450
15
68
141

answered Mar 07 '16 at 11:19

sagi

40,026
6
59
84

Working perfectly! Thank you. – John Doe Mar 07 '16 at 11:24
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. http://dev.mysql.com/doc/refman/5.7/en/update.html – Funk Forty Niner Mar 07 '16 at 12:51
@JohnDoe You're welcome John. – Funk Forty Niner Mar 07 '16 at 13:23
@Fred-ii- You're right, was in a hurry:) usually I'm posting an explanation – sagi Mar 07 '16 at 13:31

PHP - Update and set multiple variables with different WHERE

1 Answers1