-// Query based on function gl_all_accounts_list in includes/ui/ui_lists.inc.
-$sql = "SELECT chart.account_code, chart.account_name, type.name
- FROM ".TB_PREF."chart_master chart,".TB_PREF."chart_types type
- WHERE chart.account_type=type.id
- AND (
- chart.account_name LIKE " . db_escape("%" . get_post("description"). "%") . " OR
- chart.account_code LIKE " . db_escape("%" . get_post("description"). "%") . "
- )
- ORDER BY chart.account_code LIMIT 0, $limit"; // We only display 10 items.
-$result = db_query($sql, "Failed in retreiving GL account list.");
-
-$k = 0; //row colour counter