0) { echo "" . $item_num . " updated
"; } else { echo "" . $item_num . " not updated
"; } } $query = "update products set products_status = 0 where products_quantity = 0"; mysql_query($query); $num_result=mysql_affected_rows(); $query = "update products set products_status = 1 where products_quantity > 0"; mysql_query($query); $num_result=mysql_affected_rows(); fclose($fp); mysql_close($link); ?>