Codice PHP:
<?php
$db = mysql_connect("localhost", "root", "root")
or die("Errore nella connessione MySQL");
mysql_select_db("mondourania", $db) or die("Database inesistente");
$query=mysql_query ("SELECT DISTINCT autore FROM urania ORDER BY autore",$db);
?>
<form action="test4.php" method="POST" >
<select id="autore" name="autore"><?php
for($i=0;$i<mysql_num_rows($query);$i++) {?>
<option value="<?php echo mysql_result($query,$i,'autore');?>">
<?php echo mysql_result($query,$i,'autore');?>
</option><?php
}?>
</select>
<input type="submit" name="submit" value="Stampa">
</form>
in test4.php:
Codice PHP:
...
if (isset($_POST['submit'])) {
$autore = $_POST['autore'];
}
...