From 9325bafbbf17da50dd8e5855e12fdff4ed590ea1 Mon Sep 17 00:00:00 2001
From: Joe Robinson <joe@mumsnet.com>
Date: Fri, 25 Jul 2014 15:42:33 +0100
Subject: Fixed poll list to list the 5 most recent polls

---
 poll.go | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'poll.go')

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)
-- 
cgit v1.2.3