Array help

[seanmayhew]

Can somebody tell me whats wrong with my code here rather than populating the drop down list with the array from the database it just returns a drop down list with one value that reads "Array" Here is the code.

<select name="manufacture">
<?php
include("dbconnect.php");
$manquery = "select name from manufacture";
$manresult = mysql_query($manquery);
$num_manresults = mysql_num_rows($manresult);
for ($i=0;$i<$num_manresults;$i++)
{
$value = mysql_fetch_array($manresult);
echo "<option>".$value."</option>";
}
?>
</select>

Any help would be greatly appreciated.

[loopt]

Try this:

<select name="manufacture">
<?php
include("dbconnect.php");
$manquery = "select name from manufacture";
$manresult = mysql_query($manquery);
while ($r = mysql_fetch_array($manresult) {
$name = $r["name"];

echo "<option>$name</option>";
}
?>
</select>

[seanmayhew]

perfect thank you very much just missing a closing ) on the while statement

while ($r = mysql_fetch_array($manresult))