dean7 Posted September 30, 2010 Share Posted September 30, 2010 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. Quote Link to comment Share on other sites More sharing options...
petroz Posted September 30, 2010 Share Posted September 30, 2010 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>"; Quote Link to comment Share on other sites More sharing options...
Pikachu2000 Posted September 30, 2010 Share Posted September 30, 2010 One thing, remember to add a name= attribute to the <select> tag . . . Quote Link to comment Share on other sites More sharing options...
petroz Posted September 30, 2010 Share Posted September 30, 2010 Oops! Good catch! Quote Link to comment Share on other sites More sharing options...
dean7 Posted September 30, 2010 Author Share Posted September 30, 2010 Ah thanks that worked . Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.