-// Query based on function customer_list in includes/ui/ui_lists.inc.
-
-$sql = "SELECT debtor_no, name, debtor_ref, address, tax_id FROM ".TB_PREF."debtors_master
- WHERE ( name LIKE " . db_escape("%" . get_post("customer"). "%") . " OR
- debtor_ref LIKE " . db_escape("%" . get_post("customer"). "%") . " OR
- address LIKE " . db_escape("%" . get_post("customer"). "%") . " OR
- tax_id LIKE " . db_escape("%" . get_post("customer") . "%").")
- ORDER BY name LIMIT 0, $limit"; // We only display 10 items.
-$result = db_query($sql, "Failed in retreiving customer list.");
-
-$k = 0; //row colour counter