[RESOLVED] dynamic list population

[182x]

Hi, sorry for a novice question but in PHP how do you populate a list dynamically? for example I have the following in a table but I can't get them into the list after the query is performed.

<form action="">
<select name="cars">
<option value="volvo">Volvo</option>
<option value="saab">Saab</option>
<option value="fiat">Fiat</option>
<option value="audi">Audi</option>
</select>

[rincewind456]

Like this

<?php
//usual connection lines here
$query = "SELECT name FROM cars";

$result = mysql_query($query) or die(mysql_error());
while ($row = mysql_fetch_row($result)) {
	$cars[]= $row[0];
}
//$cars will then look like this
/*Array
(
    [0] => audi
    [1] => fiat
    [2] => saab
    [3] => volvo
)*/


echo "<form action=\"\">\n";
echo "<select name=\"cars\">\n";
foreach ($cars as $value){
echo "<option value=\"".$value."\">".ucfirst($value)."</option>\n";
}

echo "</select>\n";