php script error within html file
<p>i'm relatively new to this trying to get a mysql database array of Username to be shown in a html drop down input for another form however the php script just keep being shown rather than the function. below is a screenshot of the error</p>

<p><a href="http://s10.postimage.org/j4xuamkwp/untitled.png" rel="nofollow">http://s10.postimage.org/j4xuamkwp/untitled.png</a></p>

<p>the php script is sat within my html file</p>

<pre><code>&lt;?php
$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = '';
$db = 'fid';

$conn = mysql_connect($dbhost,$dbuser,$dbpass);
if (!$conn)
die('Could not connect: ' . mysql_error());

mysql_select_db($db);

echo '&lt;label class="input" for="investigator" type="input"&gt;Importance:&lt;/label&gt;&lt;select id="investigator" name="investigator"&gt;';
$resource = mysql_query("SELECT `Username` FROM `user`");
if($resource &amp;&amp; mysql_num_rows($resource)) {
    while ($row = mysql_fetch_assoc($resource)){
        echo '&lt;option value="'.$row['Username'].'"&gt;'.$row['Username'].'&lt;/option&gt;';
    }
}
echo '&lt;/select&gt;';
mysql_close($conn)
?&gt;
</code></pre>

<p>I think its an issue within the while loop however cannot fix it and its getting very frustrating! </p>
