-
-$sql = "SELECT gl.*, cm.account_name, refs.reference FROM "
- .TB_PREF."gl_trans as gl, ".TB_PREF."chart_master as cm, ".TB_PREF."refs as refs"
- ." WHERE gl.account = cm.account_code"
- ." AND gl.type= ".db_escape($_GET['type_id'])
- ." AND gl.type_no = ".db_escape($_GET['trans_no'])
- ." AND gl.type=refs.type AND gl.type_no=refs.id"
- ." ORDER BY counter";
-$result = db_query($sql,"could not get transactions");
-//alert("sql = ".$sql);