codice:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />

<title>Blockbuster Database</title>

<style type="text/css">
TD{ color:#353535; font-family:Verdana, Geneva, sans-serif}
TH{ color:#FFFFFF; font-family:Verdana, Geneva, sans-serif; background-color:#336699}
</style>

<?php
$connessione = mysql_connect("localhost", "xxx", "xxx") or die ( mysql_error());
mysql_select_db("Blockbuster") or die ( mysql_error());
?>

<?php
$moviesql = "SELECT id_attore, nome_attore FROM ATTORI";
$result = mysql_query($moviesql) or die ( "Invalid Query: " . mysql_error());
while($row = mysql_fetch_array($result)) { 
$people[$row['id_attore']] = $row['nome_attore'];
} ?>

</head>

<body>

<form action="commit.php?action=add&type=movie" method="post">

<h3 align="center"> Pannello di Inserimento Film</h3> 


<table width="750" border="1" cellspacing="1" cellpadding="3" bgcolor="353535" align="center">

<tr>
<td width="30%" bgcolor="#FFFFFF">
Titolo
</td>
<td width="70%" bgcolor="#FFFFFF">
<input type="text" name="movie_name">
</td>
</tr>

<tr>
<td bgcolor="#FFFFFF"> Movie Type </td>
<td bgcolor="#FFFFFF">

<select id="Game" name="movie_type" style="width:150px">
<?php $moviesql="SELECT id_genere, nome_genere FROM GENERE";
$result = mysql_query($moviesql) or die (mysql_error());
while($row = mysql_fetch_array($result)) {
echo '<option value=" ' . $row['id_genere'] . '"> ' . $row['nome_genere'] . '</option>' . "\r\n";
} ?>
</select>
</td>
</tr>

<tr>
<td bgcolor="#FFFFFF">Movie Year</td>
<td bgcolor="#FFFFFF">

<select name="movie_year">
<option value="" selected> Selected a Year..</option>
<?php for($year = date("Y"); $year>=1970; $year--) { ?>
<option value="<?php echo $year; ?>"><?php echo $year; ?></option>
<?php } ?>
</select>
</td>
</tr>

<tr>
<td bgcolor="#FFFFFF">Attore Protagonista</td>
<td bgcolor="#FFFFFF">
<select name="nome_attore">
<option value="" selected> Seleziona un Attore</option>
<?php foreach ($people as $id_attore => $nome_attore) { ?>
<option value="<?php echo $id_attore; ?>"><?php echo $nome_attore; ?> </option>
<?php } ?> 
</select>
</td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" align="center">
<input type="submit" name="SUBMIT" value="Add" />
</td>
</tr>
</table>
</form>
</body>
</html>