Set Selected Value Based On Database Fetched Value

Case : Hi, Stackoverflow community. I want to set selected value on SELECT type input based on fetched value from database table column. So if db table column contain 'A', SELECT t

Solution 1:

img_type is my query result and i want img_name in drop_down

 <select id="id_name"  name="photo_type" value="">
                  <option value=""></option>
                   <?php foreach($img_types as $row){ ?>
                    <option value="<?php echo $row->imgtype_id?>"><?php echo $row->imgtype_name?></option>
                    <?php } ?>
                </select>

Solution 2:

You can change your code thus:

<select name='slPayment'>
    <option>--</option>
    <option " . (($query2['via']=='Cash') ? 'selected="selected"': '') .  "value='Cash'>Cash</option>
    <option " . (($query2['via']=='Bank Transfer') ? 'selected="selected"': '') . " value='Bank Transfer'>Bank Transfer</option>
    <option " . (($query2['via']=='Credit Card') ? 'selected="selected"': '') . " value='Credit Card'>Credit Card</option>
    <option " . (($query2['via']=='Cheque') ? 'selected="selected"': '') . " value='Cheque'>Cheque</option>
    <option " . (($query2['via']=='Others') ? 'selected="selected"': '') . " value='Others'>Others</option>
</select>