Drop Down Box

[dean7]

Hi all, ive just coded a new thing for my website which lets users upgrade there car to a certain speed, its all coded and works fine, but im just not sure how todo one thing on it.

 

<?php
$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");

while($row = mysql_fetch_array($getall)){

echo $row['car']. " - ". $row['id'];
echo "<br />";
}
?>

 

That bit of my code, select the car and the car ID from my table garage, but i'm wanting it in a drop down box which shows all the cars in there garage, but not sure how I would do this.

 

Any advice?

 

Thanks.

[petroz]

This should create a dropdown menu...

<?php
$getall = mysql_query("SELECT car, id FROM garage WHERE owner='$username'");

echo "<select>";
while($row = mysql_fetch_array($getall)){

echo '<option value="'.$row['id'].'">';
echo $row['car'].'</option>';
//echo $row['car']. " - ". $row['id'];
//echo "<br />";
}

echo "</select>";

 

[Pikachu2000]

One thing, remember to add a name= attribute to the <select> tag . . .

[petroz]

Oops! Good catch!

[dean7]

Ah thanks that worked .