//include('include/connection_data.php');
if ($idcollana==200){// bis
$query="SELECT a_ed_bis.formato, a_ed_bis.size_bis as s_pag, a_ed_bis.id, a_ed_bis.anno AS DATA, a_ed_bis.cover as photo1 , 'Bis' AS collana, 'Bis' AS serie, a_comune.id FROM a_ed_bis INNER JOIN a_comune ON a_comune.id = a_ed_bis.id order by ordine desc";
}elseif ($idcollana==16){ //catalogo di mostre
if ($l==it){
$query="SELECT a_italiano.* , a_comune. *, a_collana. * FROM a_italiano INNER JOIN a_comune ON a_comune.id = a_italiano.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.curr = 4 ORDER BY id_ord desc ,a_comune.id";
}else{
$query="SELECT a_inglese.* , a_comune. *, a_collana. * FROM a_inglese INNER JOIN a_comune ON a_comune.id = a_inglese.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.curr = 4 ORDER BY id_ord desc ,a_comune.id";
}
}else if ($idcollana==201){ //limited
if ($l==it){
$query="SELECT a_italiano.* , a_comune. *, a_collana. * FROM a_italiano INNER JOIN a_comune ON a_comune.id = a_italiano.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.curr = 3 ORDER BY id_ord desc ,a_comune.id";
}else{
$query="SELECT a_inglese.* , a_comune. *, a_collana. * FROM a_inglese INNER JOIN a_comune ON a_comune.id = a_inglese.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.curr = 3 ORDER BY id_ord desc ,a_comune.id";
}
}else if ($idcollana==202){ //cataloghi bibliografici
if ($l==it){
$query="SELECT a_italiano.* , a_comune. *, a_collana. * FROM a_italiano INNER JOIN a_comune ON a_comune.id = a_italiano.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.id_collana = 12 or a_comune.id_collana = 15 or a_comune.id_collana = 19 ORDER BY a_comune.id_collana, id_ord desc ,a_comune.id";
}else{
$query="SELECT a_inglese.* , a_comune. *, a_collana. * FROM a_inglese INNER JOIN a_comune ON a_comune.id = a_inglese.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.id_collana = 12 or a_comune.id_collana = 15 or a_comune.id_collana = 19 ORDER BY a_comune.id_collana, id_ord desc ,a_comune.id";
}
}else{//non bis
if ($l==it){
$query="SELECT a_italiano.* , a_comune. *, a_collana. * FROM a_italiano INNER JOIN a_comune ON a_comune.id = a_italiano.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.id_collana =".$idcollana." ORDER BY id_ord desc ";
}else{
$query="SELECT a_inglese.* , a_comune. *, a_collana. * FROM a_inglese INNER JOIN a_comune ON a_comune.id = a_inglese.id INNER JOIN a_collana ON a_collana.id_collana = a_comune.id_collana WHERE a_comune.id_collana =".$idcollana." ORDER BY id_ord desc ";
}
}
$result = mysql_db_query(DB_NAME,$query,$conn)or die("Query non valida: " . mysql_error());
if ($idcollana==200){$dim = '210 x 297';}
elseif ($idcollana==201){$dim = 'varie';}
//elseif ($idcollana==202){$dim = 'varie';}
else {$dim = $row['dim_collana'];}
$tot= mysql_affected_rows();
$i=1;
//$rowl=mysql_fetch_array($result);
//$xml.='
'.$row1['collana'].' '.$l.' '.$idcollana.' '.$sez.'
';
//$i=1;
while($row=mysql_fetch_array($result)){//ciclo i libri
if ($idcollana==200){$dim = '210 x 297';}
elseif ($idcollana==201){$dim = 'varie misure';}
//elseif ($idcollana==202){$dim = 'varie';}
else {if($l==it) {$dim = $row['dim_collana'];}
else {$dim = $row['dim_serie'];}
}
if($i==1)
{?>
if($l==it){
if ($idcollana==16){echo "Cataloghi delle mostre";}
else if ($idcollana==201){echo "Edizioni Limitate";}
else {echo $row['collana']; }
}else{
if ($idcollana==16){echo "Exhibitions Catalogues";}
else if ($idcollana==201){echo "Limited Editions";}
else {echo $row['serie'];}
} ?>
echo $dim; ?>
} ?> //$path = "..".$row['photo1']; //creo indirizzo relativa foto
if ($row['photo1']== "" || $row['photo1']=="/archivio/zero.gif")
{$f=$row['photo2'];}
else
{$f=$row['photo1'];}
?>
$path = "..".$f; //creo indirizzo relativa foto
if($l==it){
if (strpos($row['formato'],",")==true){
$dimensione="a".str_replace(" ","",substr($row['formato'],0,strpos($row['formato'],",")));}
else{$dimensione="a".str_replace(" ","",substr($row['formato'],0));}
}
else{
if (strpos($row['s_pag'],",")==true){
$dimensione="a".str_replace(" ","",substr($row['s_pag'],0,strpos($row['s_pag'],",")));}
else{$dimensione="a".str_replace(" ","",substr($row['s_pag'],0));}
}
$dimensione.=" ".$idcollana;
?>
if ($i==4 && $showall != 1){
?>
show all ( echo $tot?> )
$showall=1;
break;
}//fine if
$i++;
}//fine while
?>