Changeset 314 for trunk/client/modules/Elezioni/index.php

Timestamp:

May 22, 2019, 5:08:14 PM (6 years ago)

Author:

roby

Message:

 

File:

• trunk/client/modules/Elezioni/index.php (modified) (1 diff)

trunk/client/modules/Elezioni/index.php

@@ -1098 +1098 @@
                 
                 $sql="SELECT t1.id_cand , t1.cognome, t1.nome, t1.num_cand, t2.id_cand, sum(t2.voti) as somma  FROM ".$prefix."_ele_candidati as t1 , ".$prefix."_ele_voti_candidati as t2
-                where t1.id_lista='$id_lista' and  t1.id_cand=t2.id_cand  group by t1.id_cand order by somma desc" ;
+                where t1.id_lista='$id_lista' and  t1.id_cand=t2.id_cand  group by t1.id_cand order by somma desc, t1.num_cand asc" ;
                 $res_candi = $dbi->prepare("$sql");
                 $res_candi->execute();