# HG changeset patch # User Matti Hamalainen # Date 1417278530 -7200 # Node ID 7d7bd913649cab64615fa686e35e71db7f139840 # Parent 06e45615b46bf8a1b99d34c64707b66982592167 Order the compos on vote page. diff -r 06e45615b46b -r 7d7bd913649c pages/vote.inc.php --- a/pages/vote.inc.php Sat Nov 29 18:08:34 2014 +0200 +++ b/pages/vote.inc.php Sat Nov 29 18:28:50 2014 +0200 @@ -119,7 +119,7 @@ " ".stGetFormHiddenInput("onerror", "noauthvote")."\n". stGetVoteButton(); - foreach (stExecSQL("SELECT * FROM compos WHERE visible<>0 AND voting<>0") as $compo) + foreach (stExecSQL("SELECT * FROM compos WHERE visible<>0 AND voting<>0 ORDER BY id") as $compo) { $esql = stPrepareSQL("FROM entries WHERE (flags & %d)=0 AND compo_id=%d", EFLAG_DISQUALIFIED, $compo["id"]); $nentries = stFetchSQLColumn("SELECT COUNT(*) ".$esql);