ecco il codice completo:
Codice PHP:
<?
$selt1=mysqli_query($conn, "SELECT*FROM film WHERE genere='$provenienza' ORDER BY titolo ASC LIMIT $prima_riga, $righe_per_pagina ");
}
while ($stampa= mysqli_fetch_assoc ($selt1))
{
$dato[$stampa[id]] = $stampa;
}
foreach ($dato as $id=>$row)
{
?>
<table width="1085" cellpadding="0" cellspacing="0" border="0" align="center" >
<tr>
<td width="50" height="38" ><?php echo ($row[id]);?></td>
<td width="154" class="dati_film_arch2"><?php echo htmlentities($row[titolo]);?></td>
<td width="163">
<a href="http://<?php echo $row[link];?>" target="_blank"><?php echo $row[link];?>
</a></td>
<td width="173">
<a href="http://<?php echo $row[link2];?>" target="_blank"><?php echo $row[link2];
?></a></td>
<td width="173" >
<?php echo htmlentities($row[foto_cop]);?></td>
<td width="162">
<?php echo htmlentities($row[foto_pic]);?></td>
<td width="72" ><div align="center">
<a href="<? echo ("modifica.php?id=$row[id]&database=$row[datab]") ?>">
[img]_immagini/note_f2.png[/img]
</a></div></td>
<td width="78"class="dati_film_arch2" ><div align="center">
[url="javascript:popWindow('<? echo ("]', 500, 250, 'app');">[img]_immagini/cancel_f2.png[/img][/url]</div>
</td>
<td width="60" class="dati_film_arch2">
<?
$titolo=$row[titolo];
//echo $titolo;
$selettrailer=mysqli_query($onn, "SELECT*FROM film_trailer WHERE titolo='$titolo'");
if ($selettrailer==FALSE){
echo ("<div align=\"center\"><a href=\"carica_trailer.php?id=$row[id]&database=$row[datab]\">
<img src=\"_immagini/publish_x.png\" width=\"16\" height=\"16\" border=\"0\" /></a></div>");
}else{
echo ("<div align=\"center\"><img src=\"_immagini/tick.png\" width=\"16\" height=\"16\" border=\"0\" /></div>");
}
?>
</td>
</tr>
</table>
<?php
}
?>