On Wednesday, September 5, 2001, at 04:50 PM, 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
If I understand your question...
In order to have your value preset in the drop down list you need
indicate that with
<option value=\"blahblah\" selected>blahblah
What I've been using for this is a hash like this:
while ($row=mysql_fetch_array($result)) {
$selected = array();
$selected[$row["store"]] = "selected";
$store=$row["store"];
$jobdesc=$row["jobdesc"];
echo "<FORM METHOD=post ACTION=update.php>";
echo "<P>Store:";
echo "<Select NAME=NameOfVariableToBePosted>"
echo " <option VALUE=\"Signal Hill\" " . $selected["Signal
Hill"] . ">Signal Hill";
echo " <option VALUE=\"Reseda\" " . $selected["Reseda"] .
">Reseda";
...etc, etc., etc.
something along those lines, anyway. So, if $row["store"] == "Signal
Hill", then $selected["Signal Hill"] will be set to "selected", while
$selected["Reseda"] and all the others will be blank.
This is a very keen thing about php.
-Steve
--
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]