Populating Drop down box with attributes from the MySQL database

[aarbrouk]

<p> Brand: <select name="BrandID" id="BrandID">

<?php

while ($row = mysql_fetch_assoc($result)){

$BrandID = $row['BrandID'];

$BrandName = $row['BrandName'];?>

<option value=<?php $BrandID?>><?php $BrandName?></option>

<?php } ?>

</select>

[aarbrouk]

<p> Brand: <select name="BrandID" id="BrandID">

<?php

while ($row = mysql_fetch_assoc($result)){

$BrandID = $row['BrandID'];

$BrandName = $row['BrandName'];?>

<option value=<?php $BrandID?>><?php $BrandName?></option>

<?php } ?>

</select>

 

sorry I submitted this thread by accident without properly explaining the problem. This is the code I have at the moment. The problem I get is when I view the form, the drop down box contains values in the drop down but doesn't actually display them on the form. The drop down just contains blank values, but they there is something there to select.

 

help would be appreciated

 

many thanks

[.josh]

You aren't actually echoing the vars in your loop.  Do:

 

<?= $variable ?>

 

or better yet (for compatibility),

 

<?php echo $variable; ?>