$sql = (SELECT SUM( B.qty ) as a_sum , A.Name FROM items AS A LEFT
JOIN crate_status AS B ON A.Name = B.Name WHERE B.procedural_code = 2 GROUP BY A.Name" or die(mysql_error());
while($result3_array = mysql_fetch_array($result)) {
$result4 = mysql_query("UPDATE `items` SET `On_Hand` = '".$result3_array['a_sum']."' WHERE `Name` =
'".$result3_array['Name']."'") or die(mysql_error()); $result=mysql_query($sql); echo $sql;