keep dropdown value selected whatever it maybe ?

[lovephp]

ok i made this dropdown which auto populate, but supposing if i store some value in db how on earth i fetch that value  matching with my following code?

 

if db value is like year 1999 how do i get it to show in my current dropdown?

 

<select name="reduyear5" required>
                <option value="" selected="selected" disabled="disabled">Select Passed Year</option>
                <option value="Persuing">Persuing</option>
                <?php
                    $start_year = date('Y')-45;
                    $end_year   = $start_year+45;
                    for($i=$start_year; $i<=$end_year; $i++){
                    echo '<option>'.$i.'</option>';
                    }
                   ?>                   
                </select>

[Muddy_Funster]

You just put a conditional check into the loop as it's constructing the option list (assuming you have already dealt with getting the desired value such as 1999) and set the selected attribute when the loop matches the conditional.

for($i=$start_year; $i<=$end_year; $i++){
if ($i == $valueFromDB){
echo "<option value='{$i}' selected='selected'>{$i}</option>";
}
else{
echo "<option value='{$i}'>{$i}</option>";
}
}

you could even use a ternary operator to condense the if/else:

($i == $valueFromDB) ? echo "<option value='{$i}' selected='selected'>{$i}</option>" : echo "<option value='{$i}'>{$i}</option>";

[lovephp]

thanks a ton mate appreciate it. cheers