- $table_name = $db_info[0];
- $type_name = $db_info[1];
- $trans_no_name = $db_info[2];
- $trans_ref = $db_info[3];
-
- $sql = "SELECT DISTINCT $trans_no_name as trans_no";
-
- if ($trans_ref)
- $sql .= " ,$trans_ref ";
-
- $sql .= ", ".$_POST['filterType']." as type FROM $table_name
- WHERE $trans_no_name >= " . $_POST['FromTransNo']. "
- AND $trans_no_name <= " . $_POST['ToTransNo'];
-
- if ($type_name != null)
- $sql .= " AND `$type_name` = " . $_POST['filterType'];
-
- $sql .= " ORDER BY $trans_no_name";
-
-
- $print_type = $_POST['filterType'];