elenco valori

[brodik]

<?php
$query = "SELECT * FROM auto WHERE id = 51 ";
$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_assoc($result))
{
print $row['marca_auto'];
print "
";
print $row['cilindrata_auto'];
print "
";
print $row['colore_auto'];
print "
";
ECC. ECC.
} ?>

<?php
$query = "SELECT * FROM marche order by desc_marche";
$res = mysql_query($query);
echo "<select name='desc_marche'>";

while($row= mysql_fetch_array($res)){
$cs = "";
if($row['marca_auto'] == $row['desc_marche']){
$cs = "selected=\"selected\"";
} 
echo "<option {$cs}>".$row['desc_marche']."</option>";
}
echo "</select>";
?>