Changeset 338 for trunk/admin/modules/Elezioni/salva_liste.php
- Timestamp:
- Nov 11, 2020, 7:38:19 PM (4 years ago)
- File:
-
- 1 edited
Legend:
- Unmodified
- Added
- Removed
-
trunk/admin/modules/Elezioni/salva_liste.php
r288 r338 50 50 51 51 global $prefix,$id_parz,$fileout; 52 $sql="SELECT tipo_cons FROM ".$prefix."_ele_consultazione where id_cons_gen='$id_cons_gen'" ; 53 $res = $dbi->prepare("$sql"); 54 $res->execute(); 55 list($tipo_cons) = $res->fetch(PDO::FETCH_NUM); 56 $sql="SELECT circo FROM ".$prefix."_ele_tipo where tipo_cons='$tipo_cons' "; 57 $res = $dbi->prepare("$sql"); 58 $res->execute(); 59 list($circo)=$res->fetch(PDO::FETCH_NUM); 60 61 if ($circo) $iscirco="and id_circ=$id_circ"; else $iscirco=''; 52 62 if($id_lista){ 53 63 $sql="select num_cand,id_cand from ".$prefix."_ele_candidati where id_cons='$id_cons' and id_lista='$id_lista' ORDER BY num_cand "; … … 62 72 } 63 73 }else{ 64 $sql="select num_lista from ".$prefix."_ele_lista where id_cons='$id_cons' ORDER BY num_lista";74 $sql="select num_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco ORDER BY num_lista "; 65 75 $result = $dbi->prepare("$sql"); 66 76 $result->execute(); … … 120 130 $result->execute(); 121 131 if($result->rowCount()){ 122 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' ";132 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 123 133 $result = $dbi->prepare("$sql"); 124 134 $result->execute(); … … 131 141 }else{ 132 142 133 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' ";143 $sql="select num_lista,id_lista from ".$prefix."_ele_lista where id_cons='$id_cons' $iscirco"; 134 144 $result = $dbi->prepare("$sql"); 135 145 $result->execute();
Note:
See TracChangeset
for help on using the changeset viewer.