devo aver fatto qualche macello

premetto che sono uno smanettone non proprio programmatore

dunque ho corretto il codice in questo modo (ho inserito l'INSERT):

<?php
$link = mysql_connect("localhost", "test", "prova")
or die("Could not connect: " . mysql_error());
mysql_select_db('news', $link)
or die ( mysql_error());


switch ($_GET['action']) {
case "edit":
$moviesql = "SELECT * FROM movie
WHERE id = '" . $_GET['id'] . "'";
$result = mysql_query($moviesql)
or die("Invalid query: " . mysql_error());
$row = mysql_fetch_array($result);
$telefono = $row['telefono'];
$email = $row['email'];
$curriculum = $row['curriculum'];
$pubblicazioni = $row['pubblicazioni'];
$ricerca = $row['ricerca'];
$didattica = $row['didattica'];
$download = $row['download'];
$informazioni = $row['informazioni'];
$link = $row['link'];

break;

default:
$telefono = "";
$email = "";
$curriculum = "";
$pubblicazioni = "";
$ricerca = "";
$didattica = "";
$download = "";
$informazioni = "";
$link = "";
break;
}
?>

<?php
$uploaddir = './uploads';
//fotografie corrisponde alla cartella nella quale vorrei fossero salvate le immagini
$uploadfile = $uploaddir . basename($_FILES['pubblicazioni']['name']);

if (move_uploaded_file($_FILES['pubblicazioni']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "File is invalid.\n!";
}
print_r($_FILES);

$query = "INSERT INTO movie (Pubblicazioni) VALUES
('".$_FILES['upfile'] ['name']."')";

$Result=mysql_query($query) or die ("Errore nella query:" . mysql_error());
echo "Record inserito con successo";
echo $_FILE['upfile']['name'];
?>

<html>
<head>
<title><?php echo $_GET['action']; ?> movie</title>
<style type="text/css">
TD{color:#353535;font-family:verdana}
TH{color:#FFFFFF;font-family:verdana;background-color:#336699}
.Stile1 {font-size: 12px}
.Stile3 {font-size: 11px}
.Stile5 {color: #FFFFFF}
body {
background-color: #e8e8e8;
}
</style>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"></head>
<body>
<form ENCTYPE="multipart/form-data" action="commit.php?action=<?php
echo $_GET['action']; ?>&type=movie&id=<?php
echo $_GET['id']; ?>" method="post">
<table border="0" width="750" cellspacing="1" cellpadding="3"
bgcolor="#353535" align="center">
<tr bgcolor="#660000">
<td colspan="2"><div align="center"><span class="Stile5">EMILIO ROSSI

<span class="Stile3">SEGRETARIO

Settore: SCUOLA MEDIA</span></span></div></td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Telefono</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="telefono"
value="<?php echo $telefono; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">E-Mail</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="email"
value="<?php echo $email; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Curriculum</span></td>
<td bgcolor="#FFFFFF" width="86%">
<textarea name="curriculum" cols="60" rows="30" width="400" height="400"><?php echo $curriculum; ?></textarea>
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Pubblicazioni</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="file" name="pubblicazioni"
value="<?php echo $pubblicazioni; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Ricerca</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="ricerca"
value="<?php echo $ricerca; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Didattica</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="didattica"
value="<?php echo $didattica; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Download</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="download"
value="<?php echo $download; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Informazioni</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="informazioni"
value="<?php echo $informazioni; ?>">
</td>
</tr>
<tr>
<td bgcolor="#cccccc" width="14%"><span class="Stile1">Link</span></td>
<td bgcolor="#FFFFFF" width="86%">
<input type="text" name="link"
value="<?php echo $link; ?>">
</td>
</tr>
<tr bgcolor="#666666">
<td colspan="2" align="center">
<input type="submit" name="SUBMIT" value="<?php
echo $_GET['action']; ?>">
</td>
</tr>
</table>
</form>
</body>
</html>