Fixed poll list to list the 5 most recent polls

2 files changed, 2 insertions, 2 deletions

diff --git a/blavote.go b/blavote.go
index 7de8a56..c14e8e4 100644
--- a/blavote.go
+++ b/blavote.go
@@ -14,7 +14,7 @@ var version string
 
 func main() {
 
-    version = "0.7.1"
+    version = "0.7.2"
 
     //Command line arguments
     var opts struct {
diff --git a/poll.go b/poll.go
index 8a204f1..eda5a8f 100644
--- a/poll.go
+++ b/poll.go
@@ -148,7 +148,7 @@ func hasUserVotedInPoll(db *sqlite3.Conn, poll Poll, user User) bool {
 
 func getRecentPolls(db *sqlite3.Conn) ([]Poll, error) {
 
-    sql := "SELECT * FROM polls LIMIT 5"
+    sql := "SELECT * FROM polls ORDER BY id DESC LIMIT 5"
     s, err := db.Query(sql)
     row := make(sqlite3.RowMap)
     var polls = make([]Poll, 5)