SQL:修改记录 - SQL:Change the record

##$query = "SELECT * FROM bookingdevice ";
$res = mysql_query($query);
echo "<table border=1><tr><td>BookingID</td><td>AccountID</td><td>ProductID</td><td>Product Name</td><td>Status</td></tr>";
while ($row = mysql_fetch_array($res)){
    echo "<tr>";
    echo "<td>".$row['bookingdeviceID']."</td>";
    echo "<td>".$row['memberaccid']."</td>";
    echo "<td>".$row['prodid']."</td>";
    echo "<td>".$row['prodname']."</td>";
    echo "<td>".$row['bookingstatus']."</td>";
    echo ("<td><input type=submit name=submit id=submit value=Update Status></td>");
    echo ("<td><input name=BookID type=hidden value=".$row["bookingdeviceID"].">");
    echo "</tr>";
    echo "</form>";
}
?>
</p>

##

$bookid = $_POST['BookID'];
    $sel_query = "SELECT * FROM bookingdevice WHERE bookingdeviceID ='".$bookid."'";
$sel_res = mysql_query($sel_query);
while ($row = mysql_fetch_array($sel_res)){
    $bookingstatus =$row['bookingstatus'];
    $prodid =$row['prodid'];
    $memberid=$row['memberaccid'];
}
$mem_query = "SELECT * FROM memberinfo WHERE memberaccid ='".$memberid."'";
$mem_res = mysql_query($mem_query);
while ($rows = mysql_fetch_array($mem_res)){
    $memberstatus =$rows['memberstatus'];
}   
if ($bookingstatus == "Normal" ){
$status_update = "UPDATE bookingdevice SET bookingstatus ='TakeOut' WHERE bookingdeviceID ='".$bookid."'";
$status_res = mysql_query($status_update);
echo "Update success!";
    echo "<meta http-equiv=refresh content=2;url=OrderSituation.php>";
}else if($bookingstatus == "TakeOut" and $memberstatus =="2" ){
    $status_update2 = "UPDATE bookingdevice SET bookingstatus ='Return' WHERE bookingdeviceID ='".$bookid."'";
$status_res2 = mysql_query($status_update2);
$sql = "UPDATE productinfo SET Quantity='1' WHERE prodid='".$prodid."'";
$sql_res = mysql_query($sql);
$upstatus_query = "UPDATE memberinfo set memberstatus = '0' WHERE memberaccid='".$memberid."'";
$upstatus_res = mysql_query($upstatus_query);
echo "Update success!";
    echo "<meta http-equiv=refresh content=2;url=OrderSituation.php>";
    }else if($bookingstatus == "TakeOut" and $memberstatus =="4" ){
    $status_update3 = "UPDATE bookingdevice SET bookingstatus ='Return' WHERE bookingdeviceID ='".$bookid."'";
$status_res3 = mysql_query($status_update3);
$sql = "UPDATE productinfo SET Quantity='1' WHERE prodid='".$prodid."'";
$sql_res = mysql_query($sql);
$upstatus2_query = "UPDATE memberinfo set memberstatus = '3' WHERE memberaccid='".$memberid."'";
$upstatus2_res = mysql_query($upstatus2_query);
echo "Update success!";
    echo "<meta http-equiv=refresh content=2;url=OrderSituation.php>";
}else if ($bookingstatus == "Return" ){
    echo "The device was return";
    echo "<meta http-equiv=refresh content=2;url=OrderSituation.php>";
}
?>##

是图片http://s29.postimg.org/gn2aaxixx/image.jpg

我只能更改最后一条记录。当我点击其他按钮时，只有最后一条记录会改变。如。我想更改bookingid22记录，当我点击bookingid22按钮时，只能更改bookingid23记录，bookingid22不能更改..........我该怎么做?我想改变同一列同一记录，谢谢

try this:

--------------
--------------
while ($row = mysql_fetch_array($res)){
    echo '<form name="form_"'.$row['bookingdeviceID'].'" method="post">';
    echo "<tr>";
    echo "<td>".$row['bookingdeviceID']."</td>";
    echo "<td>".$row['memberaccid']."</td>";
    echo "<td>".$row['prodid']."</td>";
    echo "<td>".$row['prodname']."</td>";
    echo "<td>".$row['bookingstatus']."</td>";
    echo ("<td><input type=submit name=submit id=submit value=Update Status></td>");
    echo ("<td><input name=BookID type=hidden value=".$row["bookingdeviceID"].">");
    echo "</tr>";
    echo "</form>";
}
------------------
------------------

在while作用域下添加一行新代码