prepare("SELECT description FROM sym_outlets WHERE id=?"); $stmt->bind_param("i", $outletid); $stmt->execute(); $stmt->bind_result($outlet_desc); $stmt->fetch(); echo $outlet_desc; $stmt->close(); ?>

prepare("SELECT id, name FROM sym_categories WHERE outletid=? AND active=1 ORDER BY orderno"); $stmt->bind_param("i", $outletid); $stmt->execute(); $stmt->bind_result($catid, $catname); $stmt->store_result(); if ($stmt->num_rows != 0) { while($stmt->fetch()) { $stmtprod = $mysqli->prepare("SELECT id FROM sym_products WHERE outletid=? AND productcategory=? AND isactive='Y'"); $stmtprod->bind_param("ii", $outletid, $catid); $stmtprod->execute(); $stmtprod->store_result(); $num_rows = $stmtprod->num_rows; $stmtprod->close(); if ($num_rows != 0) { $line = round($num_rows/2); ?>

prepare("SELECT shortname,salesprice,description FROM sym_products WHERE outletid=? AND productcategory=? AND isactive='Y' ORDER BY shortname LIMIT 0,?"); $stprodleft->bind_param("iii", $outletid, $catid, $line); $stprodleft->execute(); $stprodleft->bind_result($shortname, $salesprice, $description); while($stprodleft->fetch()) { ?>


IDR

 

close(); $dbprodleft->close(); ?>
prepare("SELECT shortname,salesprice,description FROM sym_products WHERE outletid=? AND productcategory=? AND isactive='Y' ORDER BY shortname LIMIT ?, ?"); $stprodright->bind_param("iiii", $outletid, $catid, $line, $num_rows); $stprodright->execute(); $stprodright->bind_result($shortname, $salesprice, $description); while($stprodright->fetch()) { ?>


IDR

 

close(); $stprodright->close(); ?>
close(); $mysqli->close(); ?>