แบบที่ 1 อันนี้รู้สึกว่าจะผิด
UPDATE equipment_serial SET equipment_status = 'ส่งเคลม' WHERE equipment_serial = '12345678'
or UPDATE spare_serial SET spare_status = 'ส่งเคลม' WHERE spare_serial = '12345678'
or UPDATE computer_serial SET com_status = 'ส่งเคลม' WHERE com_serial = '12345678';
แบบที่ 2 น่าจะถูกแต่ยาวมาก
$sql1="select * from equipment_serial where equipment_serial = '12345678'";
$sql2="select * from spare_serial where spare_serial = '12345678'";
$sql3="select * from computer_serial where com_serial = '12345678'";
$row = mysql_query($sql1);
$row2 = mysql_query($sql2);
$row3 = mysql_query($sql3);
if(mysql_fetch_array($row)){
$sql = "UPDATE equipment_serial SET equipment_status = 'ส่งเคลม' WHERE equipment_serial = '12345678'";
}
else if(mysql_fetch_array($row2)){
$sql = "UPDATE spare_serial SET spare_status = 'ส่งเคลม' WHERE spare_serial = '12345678'";
}
else if(mysql_fetch_array($row3)){
$sql = "UPDATE computer_serial SET com_status = 'ส่งเคลม' WHERE com_serial = '12345678'";
}
Load balance : Server 04
