\n";
$maxLength = 100;
while ($supplier = db_fetch_assoc($suppliers)) {
$supplier_num = $supplier['record_num'];
$supplier_name = $supplier['supplier_name'];
$query = "SELECT * FROM supplier_products " .
"WHERE supplier_num = $supplier_num " .
"AND school_num IN ($supplier_school_num,$school_num) " .
"AND product_type = 'Product' " .
"AND status = 'Active' " .
"ORDER BY sequence,product_name";
$products = db_query($query);
if (db_num_rows($products)) {
$supplier_products = array();
$products_list = "";
while ($row = db_fetch_assoc($products)) {
$entry = array();
$descr = "";
if (strlen($row['product_description'])) $descr = " - " . $row['product_description'];
$name = $row['product_name'] . "$descr (" . $row['package_qty'] . " for $currencySymbol" . number_format($row['package_cost'],2) . ")";
if (strlen($name) > $maxLength) $name = substr($name, 0, $maxLength) . "...";
$pnum = $row['record_num'];
$entry[]['num'] = $pnum;
$entry[]['name'] = $name;
$products_list .= "\n";
}
$PList .= "";
$Suppliers[] = array($supplier_num, $supplier_name, $supplier_products);
}
}
?>