-// Query based on function supplier_list in includes/ui/ui_lists.inc.
-$sql = "SELECT supplier_id, supp_name, supp_ref, address, gst_no FROM ".TB_PREF."suppliers
- WHERE (supp_name LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- supp_ref LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- address LIKE " . db_escape("%" . get_post("supplier"). "%") . " OR
- gst_no LIKE " . db_escape("%" . get_post("supplier"). "%") . ")
- ORDER BY supp_name LIMIT 0, $limit"; // We only display 10 items.
-$result = db_query($sql, "Failed in retreiving supplier list.");
-
-$k = 0; //row colour counter