- $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 ";
-
- if ($trans_ref)
- $sql .= " ,$trans_ref ";
-
- $sql .= " 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";
-
- $result = db_query($sql, "could not query transactions on $table_name");
-
- if (db_num_rows($result) == 0)
- {
- echo _("There are no transactions for the given parameters.");
- return;
- }