update form data called from database

[fpdan]

Hello all,

I have a form that users input data into, then it saves the entered information into a database. This form includes text boxes and drop down boxes.

Then there's an update page where they can go to and it displays the same form and data they previously entered and they can edit that information.

My problem lies with the drop down boxes on the update page. I call the data previously entered in the TEXT BOXS like so:

Email<br>
                        <input name="email" type="text" id="email" value="<? echo "$email"?>">

How would I have the drop down be selected with the previously entered data?
This is what I have that doesn't seem to be working:

<select name="products" id="products" value="<? echo "$products"?>">
  <option selected="selected"><? echo "$products"?></option>
  <option>AAA</option>
  <option>BBB</option>
  <option>CCC</option>
  <option>DDD</option>
                        </select>

Any ideas would be greatly appreciated!

[devinemke]

a simple example:

<?php
$products = array(
'AAA',
'BBB',
'CCC',
'DDD'
);

echo '
<form action="" method="post">
<select name="product">
';

foreach ($products as $value)
{
	echo '<option value="' . $value . '"';
	if (isset($_POST['product']) && $_POST['product'] == $value) {echo ' selected';}
	echo '>' . $value . '</option>';
}

echo '
</select><br>
<input type="submit" name="submit" value="submit">
</form>
';

if (isset($_POST['submit']))
{
	echo 'you selected ' . $_POST['product'] . ' which is still selected in the above form.  hooray!';
}
?>

[fpdan]

thanks so much...exactly what I was looking for.

[fpdan]

Thanks again for the quick reply. At first glance i though I understood how to implement that example into my form but after trying for a bit I'm still not able to get it to work.

Here's my update form: how should i implement this into my form?

<?php
	require_once('auth.php');
?>

<h1>Welcome <?php echo $_SESSION['SESS_FIRST_NAME'];?><br />
  <a href="member-profile.php"><br />
</a><a href="logout.php">Logout</a> - <a href="query-select.php"><strong>Query Select</strong></a> - <a href="quote-enter.php"><strong>Enter A New Quote</strong></a></h1>
<p>This is a password protected area only. </p>
<br />

<?
mysql_connect("xxx", "canyon1_danny", "xxx") or die(mysql_error());
mysql_select_db("database") or die(mysql_error());

$query="SELECT * FROM sales WHERE id='$id'";
$result=mysql_query($query);
$num=mysql_numrows($result); 
mysql_close();

$i=0;
while ($i < $num) {
$company_name=mysql_result($result,$i,"company_name");
$first_name=mysql_result($result,$i,"first_name");
$last_name=mysql_result($result,$i,"last_name");
$email=mysql_result($result,$i,"email");
$phone=mysql_result($result,$i,"phone");
$fax=mysql_result($result,$i,"fax");
$currentdate=mysql_result($result,$i,"currentdate");
$products=mysql_result($result,$i,"products");
$product_secondary=mysql_result($result,$i,"product_secondary");


?>

<form name="form1" method="Post" action="updated.php" enctype="multipart/form-data">
<input type="hidden" name="id" value="<? echo "$id"; ?>">
  <table width="956" border="0" align="left" cellpadding="3" cellspacing="5" bgcolor="#2C4587">
    <tr>
      <td width="940"><table width="928" border="1" cellpadding="5" cellspacing="0" bordercolor="#000000" bgcolor="#FFFFFF">
          <tr>
            <td width="924" height="569" valign="top"><table width="924" border="0" align="center">
                  <tr>
                    <td width="914"><div align="center" class="style16">-AMJ Quote Logging System-</div></td>
                </tr>
                </table>

            <table width="905" border="0" cellpadding="5" cellspacing="0">
              <tr>
                <td width="190">&nbsp;</td>
                <td width="286">&nbsp;</td>
                <td width="399">&nbsp;</td>
              </tr>
            </table>
            <table width="905" height="67" border="1" cellpadding="5" cellspacing="0">
              <tr>
                <td width="187" valign="top"><p align="left">Company Name<br />
                  <input type="text" name="company_name" id="company_name" value="<? echo "$company_name"?>"> 
                </p>
                  <p align="left">First  Name<br>
                      <input name="first_name" type="text" id="first_name" value="<? echo "$first_name"?>">
                      <br />
                  </p>
                  <p align="left">Last Name<br>
                    <input name="last_name" type="text" id="last_name" value="<? echo "$last_name"?>">
                    <br>
  </p>
                      <p align="left">Email<br>
                        <input name="email" type="text" id="email" value="<? echo "$email"?>">
                        <br>
                      </p>
                      <p align="left">Phone<br />
                        <input name="phone" type="text" id="phone" onclick="javascript:getIt(this)" value="<? echo "$phone"?>" maxlength="13" />
                      </p>
                      <p align="left">Fax<br>
                        <input name="fax" type="text" id="fax" onclick="javascript:getIt2(this)" value="<? echo "$fax"?>" maxlength="13" />
                        <br>
                      </p>
                      <p align="left">Date Entered<br />
                      <input name="currentdate" type="text" onChange="this.value='Locked text!';" value="<? echo "$currentdate"?>" size=12 readonly/>             

                      <br />
                      <br />
                      Date Last Updated<br />
                      <input name="date_updated" type="text" onChange="this.value='Locked text!';" value="<? echo "$currentdate"?>" size=12 readonly/>
<br />
<br />
Employee Name<br />
<input name="employee" type="text" id="employee" value="<? echo "$employee"?>" onchange="this.value='Locked text!';" size="12" readonly="readonly"/>
                    </p></td>
                    <td width="280" valign="top"><p align="left">Products<br>
                      <select name="products" id="products" value="<? echo "$products"?>">
  <option selected="selected"><? echo "$products"?></option>
  <option>Teledyne ISCO</option>
  <option>Barksdale</option>
  <option>Marsh Bellofram</option>
  <option>Other</option>
                      </select>
                      <br />
                      <br />
                    Secondary Product<br />
                    <input name="product_secondary" type="text" id="product_secondary" value="<? echo "$product_secondary"?>">
                    </p>
                <p align="left">Total Amount Quoted<br>
                          <input name="total" type="text" id="total" onKeyPress="return(currencyFormat(this,',','.',event))" value="<? echo "$total"?>" length=15>
                      </p>
                      <p align="left">Probability<br />
                        <select name="probability" id="probability">
                          <option selected="selected">High</option>
                          <option>Medium</option>
                          <option>Low</option>
                        </select>
                      </p>
                      <p align="left">Date Expected<br />
                        <input name="date_expected" type="text" id="date_expected" onfocus="showCalendarControl(this);" value="<? echo "$date_expected"?>" />
                      </p>
                      <p align="left">Status<br />
                        <select name="status" id="status">
                          <option>Won</option>
                          <option>Sent to Purchasing</option>
                          <option selected="selected">*Please Update</option>
                        </select>
                      </p>
                      <p align="left">Salesperson ID<br />
                        <span class="style15">
                        <select name="salespersonid" id="salespersonid" value="<? echo "$salespersonid"?>">
                          <option>&lt;? echo &quot;$salespersonid&quot;?&gt;</option>
                          <option>CEF - Centraleast Florida</option>
              <option>CTS - T Scott</option>
              <option>DAP - D Parker</option>
              <option>DNR - D Ramsey</option>
                       </select>
                        </span><span class="style15"><br>
                        </span></p>
                      <p align="left">Zip Code<br />
                      <input name="zip" type="text" id="zip" value="<? echo "$zip"?>" />
                      <br />
                      <br />
                      State<br />
                      <select name="state" id="state" value="<? echo "$state"?>">
                        <option selected="selected"><? echo "$state"?></option>
                        <option>FL</option>
                        <option>GA</option>
                        <option>TENN</option>
                      </select>
                      <br />
                      <br />
                      Terriroy ID<br />
                      <span class="style15">
                      <select name="territoryid" id="territoryid" value="<? echo "$territoryid"?>">
                        <option>&lt;? echo &quot;$territoryid&quot;?&gt;</option>
                        <option>Industrial</option>
                        <option>Municipal</option>
                        <option>Projects</option>
                        <option>Service</option>
                        <option>Exporter</option>
                                            </select>
                      </span></p>
                    <p align="left">Gross Margin<br />
%
  <input name="gross_margin" type="text" id="gross_margin" value="<? echo "$gross_margin"?>" />
  <br />
  <br />
or <br />
<br />
$
<input name="gross_marginp" type="text" id="gross_marginp" onchange="currency(this);" value="<? echo "$gross_marginp"?>" />
</p></td>
                <td width="400" valign="top"><div align="center">
                  <p><br />
                    <br />
                    <br />
                        <img src="http://www.intouch1.com/amj/amjes.jpg" width="363" height="178" /><br />
                  </p>
                  <p>&nbsp;</p>
                  <p>&nbsp;</p>
                  <p>&nbsp;</p>
                  <p>&nbsp;</p>
                  <p>&nbsp;</p>
                  <p align="left">&nbsp;</p>
                </div></td>
                  </tr>
                </table>
            <p align="left">
<br>
Attach Quote:<br>
<input type="hidden" name="MAX_FILE_SIZE" value="2000000">
<input name="userfile" type="file" id="userfile">  <br />
            </p>
            <p align="left">              Notes<br>
              <textarea name="notes" cols="100" rows="10" id="notes"><? echo "$notes"?></textarea>
              <br />
            </p></td>
          </tr>
      </table></td>
    </tr>
    <tr>
      <td height="30" valign="top"><p>
          <input type="submit" name="submit" value="upload" onClick="return validateForm()">
      </p></td>
    </tr>
  </table>
  <p><br>
  </p>
  <p class="style1">&nbsp;</p>
  <p>&nbsp;</p>
</form> 

<?
++$i;
} 
?>