CODEWITHSUNDEEP
phpmysqlsql-update
sg552
sg552

Reputation: 1543

Mysql combining update query

mysql_query("UPDATE rekod SET ns = '1' WHERE zone ='255' AND data ='$id1'");
mysql_query("UPDATE rekod SET ns = '1' WHERE zone ='255' AND data ='$id2'");

Instead of running the query twice is there a way I can update just once? There difference is only the data value. Help me please?

Upvotes: 1

Views: 95

Answers (2)

MysticXG
MysticXG

Reputation: 1437

You can use an OR statement like so:

mysql_query("UPDATE rekod SET ns = '1' WHERE zone ='255' AND (data ='$id1' OR data = '$id2')");

Upvotes: 4

Dalen
Dalen

Reputation: 8996

"UPDATE rekod SET ns = '1' WHERE zone ='255' AND data IN('$id1','$id2')"

or

"UPDATE rekod SET ns = '1' WHERE zone ='255' AND (data='$id1' OR data='$id2')"

Upvotes: 7

Related Questions