> Hello,
> Here is the code I have:

sure, your query is something like:
select ..., store,  jobdesc ...... FROM ......

why using:
>    $store=$row["store"];
>    $jobdesc=$row["jobdesc"];
echo"dhdhdh".$row["store"]."blabla" would also work

i should use:
while (LIST($store,$jobdesc)=mysql_fetch_row($result)) {
.

----- Original Message ----- 
From: "Jeff Grossman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, September 05, 2001 11:50 PM
Subject: [PHP-DB] Forms Question


> 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
> 
> -- 
> Jeff Grossman ([EMAIL PROTECTED])
> 
> -- 
> 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]
> 


-- 
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