grazie, ho risolto così
Codice PHP:
<div>[url="index.php"]torno al menù principale della città[/url]</div>
<?php
$citta ="roma";
$link=mysql_connect("******","******","******")
or die ("Non riesco a connettermi a [b]$db_host");
@mysql_select_db (******, $link)
or die ("Non riesco a selezionare il db $database
");
if (isset($_REQUEST['nome'])){
$dati=" INSERT INTO images VALUES (NULL,
'".$_REQUEST['file1']['name']."',
'".$citta."',
'".$_REQUEST['album']."'
)";
mysql_query ($dati, $link)
or die ("Non riesco ad eseguire la query $dati");
Echo "I Dati sono stati archiviati con successo nel DataBase $database";
mysql_close ($link);
echo "<meta http-equiv=refresh content=3;url=$PATH_INFO>";
}
$uploaddir2 = 'album/';
$uploadfile = $uploaddir2 . basename($_FILES['file1']['name']);
echo "<pre>";
if (move_uploaded_file($_FILES['file1']['tmp_name'], $uploadfile)) {
echo "File is valid, and was successfully uploaded.\n";
} else {
echo "\n";
}
echo ':';
print_r($_FILES);
print "</pre>";
?>
<html>
<head>
<title>Form dati</title>
</head>
<body>
<TABLE border=0 width=100% cellpadding=3>
<tr>
<td width=100% colspan=2>
<p align=center>[b]
<form method="POST" enctype="multipart/form-data" action=<? $PATH_INFO ?>>
[/b]</td>
</tr>
<tr>
<td>[b]seleziona immagine[/b]
<input type=file name=file1 size=20></td>
</tr>
<tr>
<td>
[b]seleziona album[/b]
<select name="album">
<?php include("elencoalbum.php") ?>
</select>
</td>
</tr>
<tr>
<td width=18%>[b]<input type=submit value=Inserisci nuovi dati>[/b]</td>
<td width=82%></form></td>
</tr>
</table>
</body>
</html>