Results 1 to 2 of 2

Thread: Multiple update

  1. #1
    Join Date
    Apr 2004
    Posts
    6

    Unanswered: Multiple update

    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?

  2. #2
    Join Date
    Apr 2004
    Posts
    6
    Please disregard the above message.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •