$elenco_collane = array (1,17,3,200,4 ,18,7,2,20,5,6,8);//le collane che vogliono in elenco da qui
foreach ($elenco_collane as $idcoll) {
if ($l==it){//italiano
if ($idcoll==200){//italiano bis
$query="SELECT 'Bis' as collana, a_italiano.titolo,a_comune.photo2,a_italiano.testo,a_italiano.lingua,a_ed_bis.cover as photo1,a_ed_bis.anno as data,a_ed_bis.price as euro,a_ed_bis.formato FROM a_comune inner join a_italiano on a_comune.id=a_italiano.id INNER JOIN a_ed_bis ON a_ed_bis.id= a_comune.id order by ordine desc";
}
else //italiano collane
{
$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 =".$idcoll." ORDER BY id_ord desc";
}
}else{//inglese
if ($idcoll==200){//inglese bis
$query="SELECT 'Bis' as serie, a_inglese.title ,a_comune.photo2,a_inglese.text,a_inglese.lang,a_ed_bis.cover as photo1, a_ed_bis.anno as p_date, a_ed_bis.price as euro,a_ed_bis.size_bis as s_pag FROM a_comune inner join a_inglese on a_comune.id=a_inglese.id INNER JOIN a_ed_bis ON a_ed_bis.id= a_comune.id order by ordine desc";
}
else //inglese collane
{
$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 =".$idcoll." ORDER BY id_ord desc";
}
}
$result = mysql_db_query(DB_NAME,$query,$conn)or die("Query non valida: " . mysql_error());
$tot= mysql_affected_rows();//totale di quella collana
$i=1;
while($row=mysql_fetch_array($result)){//ciclo i libri
if($i==1){?>
//primo record di quella collana
if ($idcoll==200){$dim = '210 x 297';}//per i bis definisco la dimensione
else {
if ($l==it){$dim = $row['dim_collana'];}
else {$dim = $row['dim_serie'];}
}//dimensione dal database
if($l==it)
{?> echo $row['collana'];?> }
else{?> echo $row['serie'];?> }?>
echo $dim;?>
}
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.=" ".$idcoll;
?>
if ($i==4 || ($tot<4 && $i==$tot)){
//al limite aggiungo copertine vuote
?>
$showall=1;
break;
}//fine if
$i++;
}//fine while
}//fine foreach
?>