The solution is easier than you think.  You'll need to insert an if 
statement in your option html tag that says

echo "<option VALUE=\"Signal Hill\">Signal Hill\n";
should become:

echo "<option VALUE=\"Signal Hill\"";
if ($store == 'Signal Hill') { print " selected"; }
echo ">Signal Hill</option>\n";

Jeff Grossman wrote:

>Hello,
>Here is the code I have:
>
>while ($row=mysql_fetch_array($result)) {
>   $store=$row["store"];
>   $jobdesc=$row["jobdesc"];
>echo "<FORM METHOD=post ACTION=update.php>";
>echo "<P>Store:
>      <Select NAME=\"$store\">
>         <option VALUE=\"Signal Hill\">Signal Hill
>         <option VALUE=\"Reseda\">Reseda
>         <option VALUE=\"Orange\">Orange
>         <option VALUE=\"West Covina\">West Covina
>         <option VALUE=\"Riverside\">Riverside
>         <option VALUE=\"Norwalk\">Norwalk
>         <option VALUE=\"Fountain Valley\">Fountain Valley
>         <option VALUE=\"Pasadena\">Pasadena
>         <option VALUE=\"Redondo Beach\">Redondo Beach
>         <option VALUE=\"San Bernardino\">San Bernardino
>         <option VALUE=\"Kearny Mesa\">Kearny Mesa
>         <option VALUE=\"San Marcos\">San Marcos
>         <option VALUE=\"Chino\">Chino
>         <option VALUE=\"Coporate Office\">Corporate Office
>      </select></P>";
>echo "<P><INPUT TYPE=text SIZE=35 NAME=\"Jobdesc\" 
>VALUE=\"$jobdesc\"></P>";
>echo "<p><INPUT TYPE=submit VALUE=\"submit\" LABEL=\"Save 
>Changes\"></P>";
>}
>
>
>Is want I am trying to do possible?  I want the value which is stored in 
>$store to automatically fill in on the drop down list.  But, for some 
>reason it is defaulting to the first option, and not using the value 
>that is in the database.
>
>Can I use a drop down menu, or should I just go to radio buttons?
>
>Thanks,
>Jeff
>




-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to