Autofilling dropdown box

[madmax]

Hello all

I am trying to autofill a dropdown list and am not sure how to construct it, I got this far:

[php]
if(($_GET['vehicle_type'] == 'Ford')){

$query = mysql_query("SELECT vehicle_make FROM vehicles WHERE vehicle_type='Ford'"); // autofill dropdown list 'select' with options from DB
$r = mysql_fetch_array($query);

$size=explode(',', $r['vehicle_make']);
for($i=0;$vehicle_make[$i];$i++)
{
echo "<option value=$vehicle_make[$i]>$vehicle_make[$i]</option>";
}
}

[php]

the resulty is no options in the dropdown box ? -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[parker1]

Try this code

<?php
echo '<select>';
$query = mysql_query("SELECT vehicle_make FROM vehicles WHERE vehicle_type='Ford'");
while ( $r = mysql_fetch_row($query) ){
echo '<option value="'. $r[0] .'">'. $r[0] ."</option>\n";
}
echo '</select>';
?>


Hope I was of little help -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --