X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Ftransactions_db.inc;h=19d22970c68b0c1f294f3d5bacd740735fdf7725;hb=0b63d898491b6577a5a5bf90e771dca0dcbbcf1f;hp=293e8f4d0aad1dcec2ef45825cd603864260aa4e;hpb=602836d36728a0c3874ac90db0aaa8892826908d;p=fa-stable.git

diff --git a/admin/db/transactions_db.inc b/admin/db/transactions_db.inc
index 293e8f4d..19d22970 100644
--- a/admin/db/transactions_db.inc
+++ b/admin/db/transactions_db.inc
@@ -56,8 +56,12 @@ function get_sql_for_view_transactions($filtertype, $from, $to, &$trans_ref)
 		$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)));
+}
+?>