[RESOLVED] Show value in Form field

[yanks6rule]

I am having this problem that I can't seem to figure out. I have a drop down menu on a form using select. When a person returns and I query their information I want to have this drop down menu already on the value they selected when they registered. I can't seem to get it to work though. I have isolated the code and I will display it below and help would be appreciated. If you view the page source it says that the value is selected correctly. I have tried using <option selected> but I might be using it wrong as well.

<?php
include "mysql_connect_snacks.php";
$db = mysql_select_db("chemdata");
$q = "SELECT advisor FROM alumni WHERE pid=5";
$r = mysql_query($q);
$row = mysql_fetch_assoc($r); 

$form = "<form method=\"POST\" method=\"$PHP_SELF\">
<p><select name=\"advisor\" value=\"". $row['advisor']. "\"></p>
<option value=\"select\">Please Select Advisor</option>
<option value=\"Maroney\">Maroney</option>
<option value=\"Knapp\">Knapp</option>
<option value=\"Lahti\">Lahti</option>
</select>

<p><input type=\"hidden\" name=\"ds\" value=\"op\" /></p>
<p><input type=\"submit\" name=\"submit\" value=\"subimt\" /></p>
</form>";
if ($_POST['ds'] != "op") {
  echo "$form";
}
else if ($_POST['ds'] == "op") {
  if ($_POST['advisor'] == "Please Select Advisor") {
    echo "Did not select advisor";
    header("Location: option.php");
}
else {
  echo "You selected an advisor<br />";
}
}
?>

Thanks

[Installer]

Try this:

$advisors = array('Maroney', 'Knapp', 'Lahti');
$form = '<form method="POST" action="' . $_SERVER['PHP_SELF'] . '">' .
        '<p><select name="advisor"></p>';

foreach ($advisors as $advisor) {
    $form .= '<option value="' . $advisor . '"';
    if ($advisor == $row['advisor']) {
        $form .= ' selected="selected"';
    }
    $form .= '>' . $advisor . '</option>';
}

$form .= '</select>' .
         '<p><input type="hidden" name="ds" value="op" /></p>' .
         '<p><input type="submit" name="submit" value="submit" /></p>';
         '</form>';

[yanks6rule]

This script worked great. I am not trying to apply it to my whole page and I run into one problem and this is wierd in my opinion. If I type in the array myself the script works. If I use the command $advisors = file('file'); to arrange my array this does not work. The file I am referring to lists all the advisors out in a file like so:
advisor1
advisor2
advisor3
so and so forth

When I use print_r to show the array it seems to work fine. Is there something I am missing when I use the file command versus the array command.

Thanks

[Installer]

The "file()" function keeps the newlines and/or carriage returns, so you need to use "trim()" on each element. Otherwise the element won't match the name.

foreach ($advisors as $advisor) { 
    $advisor = trim($advisor);    

    $form .= '<option value="' . $advisor . '"'; 
    // etc.

Also make sure the upper/lowercases match. Or do:

if (strtolower($advisor) == strtolower($row['advisor'])) {

[yanks6rule]

Worked great, thank you