$sql .= " AND t.`amount` <> 0";
$sql .= " GROUP BY ".($type_name ? "t.$type_name," : '')." t.$trans_no_name";
- $sql .= " ORDER BY t.$trans_no_name";
+ $sql .= " ORDER BY t.$trans_no_name DESC";
return $sql;
}
-?>
\ No newline at end of file
+function transaction_exists($trans_type, $trans_no)
+{
+ return db_num_rows(db_query(get_sql_for_view_transactions($trans_type, $trans_no, $trans_no, $dummy)));
+}
+?>