";
$res = mysql_query("SELECT * FROM ".$prefix."_ele_circoscrizione where id_cons='$id_cons'", $dbi);
echo "";
echo "
";
$circo="and id_circ='$id_circ'";
$circo2="and t2.id_circ='$id_circ'";
}
if($id_cand)
{
$res = mysql_query("SELECT * FROM ".$prefix."_ele_candidati where id_cand='$id_cand'", $dbi);
$pro= mysql_fetch_array($res, 3);
}else{
$pro['cognome']='';$pro['num_cand']='';$pro['nome']='';
}
if (!isset($id_lista)) {
$res_lista=mysql_query("SELECT id_lista from ".$prefix."_ele_lista where id_cons=$id_cons $circo and num_lista=1", $dbi);
list($id_lista)=mysql_fetch_row($res_lista);
}
$cond=($id_lista>0) ? "and t1.id_lista=".$id_lista :'';
echo "
"._CANDIDATO."
"
."
"._NUM."
"
."
"._COGNOME."
"
."
"._NOME."
";
echo "
"._LISTA."
";
if ($genere==3 or $genere==5) {
$query= "SELECT
t1.id_cand,t1.id_lista,t1.num_cand,t1.cognome,t1.nome, t1.simbolo,
t2.simbolo as sim_lista,t2.descrizione, t3.simbolo as sim_gruppo, t3.descrizione
FROM ".$prefix."_ele_candidati as t1,
".$prefix."_ele_lista as t2,
".$prefix."_ele_gruppo as t3
WHERE t1.id_lista=t2.id_lista
and t2.id_gruppo=t3.id_gruppo
and t1.id_cons=t2.id_cons
and t1.id_cons=$id_cons $circo2
$cond
order by t2.num_lista, t1.num_cand
limit $min,$offset";
} else {
$query= "SELECT
t1.id_cand,t1.id_lista,t1.num_cand,t1.cognome,t1.nome, t1.simbolo,
t2.simbolo as sim_lista,t2.descrizione, '', ''
FROM ".$prefix."_ele_candidati as t1,
".$prefix."_ele_lista as t2
WHERE t1.id_cons=$id_cons
and t1.id_cons=t2.id_cons
and t1.id_lista=t2.id_lista $circo2
$cond
order by t2.num_lista,t1.num_cand
limit $min,$offset";
}
echo "
"._FUNZIONI."
";
$result = mysql_query($query, $dbi);
if($cons_circ)
$res = mysql_query("SELECT count(0) FROM ".$prefix."_ele_candidati as t1,".$prefix."_ele_lista as t2 where t1.id_cons='$id_cons' and t1.id_cons=t2.id_cons and t2.id_circ=$id_circ and t1.id_lista=t2.id_lista $cond ", $dbi);
else
$res = mysql_query("SELECT count(0) FROM ".$prefix."_ele_candidati as t1 where t1.id_cons='$id_cons' $cond ", $dbi);
list($max) = mysql_fetch_row($res);
if($id_lista){
$numero=$max+1;} else $numero='';
//-----------------------lo stemma e la circoscrizione devono essere associati alla lista -
echo "
";
#'Pagina precedente' e 'Pagina Successiva'
echo"