I would think you would want the "name" of your select to be "store" and not
"$store". That way the value will be in the variable $store when the form
is submitted.
Now, as I understand, what you want is for the value of $store from the
database to be preselected when the form is displayed. You can do that by
modifying your code as follows:
> 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\">
<-- remove "$"
<option VALUE=\"$store\" selected>$store <-- add
this line
<option VALUE=\"\"> ---
<-- add this line
> <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>";
> }
The store that is in the database will be listed twice -- at the top of the
list, and then in its normal position in the list. The "---" line is just
to serve as a visual seperator between the selected store and the complete
list of stores, for the person filling out the form.
--
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]
