<?php
include 'library/connect.php';
$result = mysql_query("SELECT film.pics, film.film_id, film.fname, film.dname from film");
echo '<table border="1">
<tr>';
while($row = mysql_fetch_array($result)){
$pics = $row["pics"];
$filmid = $row["film_id"];
$fname = $row["fname"];
echo "
<td><img src=\"gallery/.jpg\" alt=\"\" width=\"150\" height=\"150\"/></td>";
echo "<td id=\"table\">$fname</br> <a href =\"Details.php?id=$filmid\">More about this film</a></td>";
$x = $x+1;
if($x==2){
echo "</tr><tr>";
$x=0;
}
}
echo'
</tr>
</table>
';
include 'library/close.php';
?>