<?php
error_reporting(E_ALL);
ini_set('display_errors', '1');

include_once "config.php";
$pat_id       = (int) $_GET['pat_id'];
//let's build the dropdown query
$dd_loc_query = "SELECT * from `offices`";
$dd_loc_result = mysql_query($dd_loc_query) or die(mysql_error());

$result = mysql_query("SELECT * FROM patients WHERE pat_id = $pat_id") or die(mysql_error());
$row = mysql_fetch_array($result);

?>

<form action="" method="post">
<input type="hidden" name="pat_id" value="<?= $pat_id; ?>">
<div><label for="Patient_name"><h2>Editing Patient<h2></label></div>
<div><label for="Patient_name">Patient First Name: </label><input type="text" value="<?= $row['pat_fname'] ?>" name="pat_fname"/></div>
<div><label for="Patient_name">Patient Last Name: </label><input value="<?= $row['pat_lname'] ?>" type="text" name="pat_lname"/></div>
<div><label for="Patient_name">Office location: </label>
<select name="pat_loc">
<?php
    while ($dd_loc_row = mysql_fetch_array($dd_loc_result)) {
        echo "<option value=\"" . $dd_loc_row['office_id'] . "\">" . $dd_loc_row["office_name"] . "</option>";
    }
?>
</select>
</div>