0) { // Process each supplier while ($supplier = db_fetch_array($suppliers)) { $supplier_num = $supplier['record_num']; $supplier_name = $supplier['supplier_name']; $sname = $SchoolNames[$supplier['school_num']]; $supplier_name .= " ($sname)"; $query = "select * from supplier_products " . "where supplier_num = $supplier_num " . "and school_num = $supplier_school_num " . "and product_type = 'Product' " . "AND status = 'Active' " . "order by sequence,product_name"; $products = db_query($query); // Process each product if (db_num_rows($products) > 0) { while ($row = db_fetch_array($products)) { $name = $row['product_name'] . " (" . $row['package_qty'] . " for $currencySymbol" . number_format($row['package_cost'],2) . ")"; $pnum = $row['record_num']; $allProducts[] = array("supplier_num" => $supplier_num, "supplier_name" => $supplier_name, "product_num" => $pnum, "product_name" => $name); } } } } // Exit if there are no products if (count($allProducts) == 0) { $error_message = getLanguageText('ERRORMSG-NO-PRODUCTS-DEFINED'); header("Location: /?error_message=" . urlencode($error_message)); exit(); } ?>

Menu Product Update -

ITEM PRODUCT PRODUCT PRODUCT -- -- ::       = $pn) { $curr_product_num = $Products[$pn - 1]['supplier_product_num']; $curr_product_qty = $Products[$pn - 1]['supplier_product_qty']; } $qty_field = "qty$pn"."_$menu_item_num"; $product_field = "product$pn"."_$menu_item_num"; ?> 0) echo(" \n"); echo(" \n"); $prevSupplier = $product['supplier_num']; } $selected = ""; if ($curr_product_num > 0 && $curr_product_num == $product_num && $curr_product_qty > 0) $selected = " selected='selected'"; echo(" $product_name\n"); } echo(" \n"); ?>