From 7d9fdac2f81405b2afbe0a82066dff5481b9c093 Mon Sep 17 00:00:00 2001 From: Metabox Date: Wed, 15 May 2019 18:19:03 +1000 Subject: [PATCH] order by date presedence. --- htdocs/cgi-bin/main.cgi | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/htdocs/cgi-bin/main.cgi b/htdocs/cgi-bin/main.cgi index ff09038..88c064f 100755 --- a/htdocs/cgi-bin/main.cgi +++ b/htdocs/cgi-bin/main.cgi @@ -122,7 +122,7 @@ my $today = DateTime->now; my $stmtCat = "SELECT * FROM CAT;"; -my $stmt = "SELECT rowid, ID_CAT, DATE, LOG, AMMOUNT FROM LOG ORDER BY rowid DESC, DATE DESC;"; +my $stmt = "SELECT rowid, ID_CAT, DATE, LOG, AMMOUNT FROM LOG ORDER BY DATE DESC, rowid DESC;"; $st = $db->prepare( $stmtCat ); -- 2.34.1