select name

[novizio1]

<?php
include "database.php";
$query = "SELECT prodotto,prezzo FROM magazzino where visibile = 'v' order by prodotto;";
$dati = mysql_query($query, $DB);
while($row = mysql_fetch_row($dati))
{
echo "<option value = '$row[1]'>$row[0]</option>";
}
echo "</select>";
mysql_close($DB);
?>

mi stampa solo prodotto.

<?php
include "database.php";
$query = "SELECT prodotto,prezzo FROM magazzino where visibile = 'v' order by prodotto;";
$dati = mysql_query($query, $DB);
while($row = mysql_fetch_row($dati))
{
echo "<option value = '$row[0]'>$row[1]</option>";
}
echo "</select>";
mysql_close($DB);
?>
mi stampa solo prezzo.