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

Timestamp:

May 22, 2019, 4:56:53 PM (5 years ago)

Author:

roby

Message:

 

File:

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

trunk/client/modules/Elezioni/index.php

@@ -924 +924 @@
                 
                 $res_candi = mysql_query("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" , $dbi);
+                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" , $dbi);
                 //$res_candi = mysql_query("SELECT id_cand , cognome, nome, num_cand  FROM ".$prefix."_ele_candidati 
                 //where id_lista='$id_lista'  and id_cons='$id_cons order by num_cand" , $dbi);