Changeset 263 for trunk/admin/modules/Elezioni

Timestamp:

Apr 7, 2019, 5:28:53 PM (6 years ago)

Author:

roby

Message:

 

Location:

trunk/admin/modules/Elezioni

Files:

• controllo_aff.php (added)
• ele_colora_sez.php (modified) (1 diff)

trunk/admin/modules/Elezioni/ele_colora_sez.php

@@ -15 +15 @@
         $res->execute();        
         }else{ #candidati
-        $sql="SELECT t2.id_lista FROM ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on t1.id_cand=t2.id_cand where t1.id_cons='$id_cons' and t1.id_sez='$id_sez' group by t2.id_lista";
+        $sql="SELECT count(t2.id_lista) FROM ".$prefix."_ele_voti_candidati as t1 left join ".$prefix."_ele_candidati as t2 on t1.id_cand=t2.id_cand where t1.id_cons='$id_cons' and t1.id_sez='$id_sez' group by t2.id_lista";
         $res = $dbi->prepare("$sql");
         $res->execute();
-        $liste=$res->rowCount();
+        list($liste)=$res->fetch(PDO::FETCH_NUM);
         
         $sql="SELECT count(id_lista) FROM ".$prefix."_ele_lista where id_cons='$id_cons'";