PHP show drop down selected based on value [closed

Question

This question is unlikely to help any future visitors; it is only relevant to a small geographic area, a specific moment in time, or an extraordinarily narrow situation that is not generally applicable to the worldwide audience of the internet. For help making this question more broadly applicable, visit the help center.

Closed 6 years ago.

I want to show a drop down selected for some value which is coming from database.

    <select name="plans">
       <option>MAP</option>
       <option>CP</option>
       <option>CPA</option>
       <option>CPF</option>
    </select>

Reading a value from database in PHP/Mysql, lets say "CPA", how do I show this option selected?

Answer 1

Try like this

<select name="plans">
   <option <?php echo ($value == "MAP")?"selected":"" ?> >MAP</option>
   <option <?php echo ($value == "CP")?"selected":"" ?> >CP</option>
   <option <?php echo ($value == "CPA")?"selected":"" ?> >CPA</option>
   <option <?php echo ($value == "CPF")?"selected":"" ?> >CPF</option>
</select>