如何从数据库中获取值时从Dropbox中选择选项值？ [关闭]

Question

From mySQL and PHP I get the option value from the DB. I have a edit.php page where the user can edit his previous choice. How can I have the selected value shown if the below is HTML and not from the Database?

Thank you

 <option value="2014">2014</option>
 <option value="2013">2013</option>
 <option value="2012">2012</option>
 <option value="2011">2011</option>
 <option value="2010">2010</option>
 <option value="2009">2009</option>
 <option value="2008">2008</option>

Answer 1

let say you have array $abc containing the data to populate the select DOM

and you have array $qwe containing detail of the user(or whatever module you editing)

for array

<option value="<?php echo $abc['name_of_column'];?>" <?php if($abc['name_of_column'] == $qwe['name_of_column'] ){echo "selected='selected'";}?>>2014</option>

for object

<option value="<?php echo $abc->name_of_column;?>" <?php if($abc->name_of_column == $qwe->name_of_column){echo "selected='selected'";}?>>2014</option>