I have tried to update multiple records in a single table and I have not been able to figure thei out. I have tried:

$query1="UPDATE quantity (branch_number, pipe_id, quantity)
SET '$branch', '001', '$qty1'
WHERE branch_number = $branch and pipe_id = pipe_id";

$query2="UPDATE quantity (branch_number, pipe_id, quantity)
SET '$branch', '002', '$qty2'
WHERE branch_number = $branch and pipe_id = pipe_id";

mysql_query=$query1;
mysql_query=$query2;


Anyone know why this wouldn't work?

Please disregard the above message.