Php选择基于动态下拉列表的默认下拉列表

Question

Building an edit users form for my system and having a little trouble trying to figure out how to do a selected="selected" for the value in the dropdown that goes with the users information in the database.

This is my code: http://pastebin.com/EVdUfTzN

The names of the offices are stored in one table called offices and the value of the office that the patient went to is stored in patients. Basically I want to select the information from both tables and add a selected option on it.

Here is picture of the offices table

Here is a picture of the patients table

Do you understand what i am trying to do? Maybe even simplify it so its one query with INNER JOIN

Answer 1

Try this (replace lines 25-29):

<?php
while ($dd_loc_row = mysql_fetch_array($dd_loc_result)) {
    echo "<option value=\"" . $dd_loc_row['office_id'] . "\"".($row['pat_loc'] == $dd_loc_row['office_id'] ? ' selected="selected"' : '').">" . $dd_loc_row["office_name"] . "</option>";
}
?>