cevap icin sagol. tekrardan bir query yapmak zorunda kaldim. simdi calisiyor.
for ($i=0;$i<=count($item_id);$i++)
{
$query = mysql_query("UPDATE item SET worker_id = '".$worker[$i]."', item_done = '".$work_done[$i]."' WHERE item_id = '".$item_id[$i]."' ") or die(mysql_error());
}
$query = "SELECT COUNT(*) as num FROM item WHERE order_reference_number = '".$newReference."' AND item_done = 'No' ";
$total_pages = mysql_fetch_array(mysql_query($query));
$total_pages = $total_pages[num];
if ($total_pages >= 1)
{
$query = mysql_query("UPDATE orderr SET order_ready = 'No' WHERE order_id = '".$order_id."' ") or die(mysql_error());
}
else
{
$query = mysql_query("UPDATE orderr SET order_ready = 'Yes' WHERE order_id = '".$order_id."' ") or die(mysql_error());
}