php select box from database

[techker]

Hey guys i have a products site and i put an edit product page , i need to put in a form of select box the database info but highlight the result in the table..

 

 

ok so lets say product car

 

name

id

type

brand ---> select box to edit the brand (select * from Brands) but incase he does not want to change that info i need the default to be the info stores already?

 

brand Honda -->select box highlight Honda 

 

this is the select i have 

div class="form-group">
    <label for="exampleInputName2">Brand :  <? echo $row['Brand'] ?></label>
   
    <select name="Brand"> 
    <?php 
while ($row2 = mysqli_fetch_array($result2))
{
 echo "<option value='".$row2['Name']."'>".$row2['Name']."</option>";
}
?>   

[requinix]

The output you need to get is

Honda

[Sepodati]

You have the "id" of the product you're editing and each row has an "id". When they are the same, add the "selected" tag to the <option>.

[techker]

this shows the list and the value

 

echo "<option value='".$row['Name']."'>".$row['Name']."</option>";

 

if i put honda it waill always put the value?

[cyberRobot]

So...$result2 contain all the possible brand options, correct?

 

If so, you should be able to add the "selected" attribute to the <option> tag when $row['Brand'] == $row2['Name'].