Value of a combobox based upon a php value

[fragmaster]

Hi,

Im having a problem with a combo box. I am retreiving a value from a MySQL database that coresponds to a value in the combo box. Probably best if i show the code and people might understand what im on about...

<td>Location:<br>
<select name="location" id="location" value="<?PHP PRINT("$location"); ?>">
<option value="null">(Please Select)</option>
<option value="L001">Kitchen</option>
<option value="L002">Attendance Office</option>
<option value="L003">Personal Office</option>
<option value="L004">Reception</option>
<option value="L005">Main Office</option>

Lets say that $location = L004, when the page loads i want the combobox to display "Reception" instead of "(Please Select)".

This method seems to work when populating the value of a text field but im having no luck with combo boxes.

Any help would be greatly appreciated.

[Kudose]

Here is one way

<select name="location">
<?php
  foreach($locations as $key => $location){
    echo '<option value="'.$key.'"';
    if($key == 'L004') echo ' selected';
    echo '>'.$location.'</option>';
  }
?>
</select>

From you code though, I think you want

<select name="location" id="location">
<option value="null">(Please Select)</option>
<option value="L001"<?php if($location == 'L001') echo ' selected'; ?>>Kitchen</option>
<option value="L002"<?php if($location == 'L002') echo ' selected'; ?>>Attendance Office</option>
<option value="L003"<?php if($location == 'L003') echo ' selected'; ?>>Personal Office</option>
<option value="L004"<?php if($location == 'L004') echo ' selected'; ?>>Reception</option>
<option value="L005"<?php if($location == 'L005') echo ' selected'; ?>>Main Office</option>

[fragmaster]

NICE! thank you very much, your second code example has work perfectly. Thank you very much. 🙂