Update multiple values in WHERE MySQL

Question

I want to update multiple itemIDs with the same status. I know that this is imposible with mysql_query but I can't figure out a way to get this working.

     $upd = "UPDATE booking SET status='$status' WHERE itemID='$itemID', '$itemID2'";
     $retval = mysql_query($upd, $con);

Note: The itemIDs are inputted by user in prev page like this

     $itemID= $_POST["itemID"];
     $itemID2= $_POST["itemID2"];

where itemid in (itemid1, itemid2) will do the trick.

shree.pat18
– shree.pat18

2015-01-12 09:36:05 +00:00
Commented Jan 12, 2015 at 9:36 — shree.pat18
– shree.pat18, Commented Jan 12, 2015 at 9:36

SMA · Accepted Answer · 2015-01-12 09:36:08Z

2

Use IN clause as like:

WHERE itemId in ('$itemID', '$itemID2');

instead of WHERE itemID='$itemID', '$itemID2'

answered Jan 12, 2015 at 9:36

SMA

37.2k8 gold badges53 silver badges76 bronze badges

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

1 Comment

Snoken Over a year ago

Works like a charm and it was a so easy fix, thanks1 :D

Barmar · Accepted Answer · 2015-01-12 09:36:17Z

1

Use IN

$upd = "UPDATE booking SET status='$status' WHERE itemID IN ('$itemID', '$itemID2')";

answered Jan 12, 2015 at 9:36

Barmar

789k57 gold badges554 silver badges669 bronze badges

Collectives™ on Stack Overflow

Update multiple values in WHERE MySQL

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related