Post data to db and to a form at same time?

[leob]

Can anyone suggest a method to enter data supplied for an insert as input for a form in the same process?

Here is the insert portion of the code:

    <th scope="col" align="right">If County is not listed enter info here: </th>
    <th scope="col"><form method="post" name="form3" action="<?php echo $editFormAction; ?>">
      <table align="center">
          <tr valign="baseline">
            <td nowrap align="right">county:</td>
            <td><input type="text" name="County" value="" size="32"></td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">metro:</td>
            <td align="left"><input type="radio" name="metro" value="yes" >
                    Yes<input type="radio" name="metro" value="no" >No</td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">&nbsp;</td>
            <td><input type="submit" value="Insert record"></td>
          </tr>
        </table>
        <input type="hidden" name="MM_insert" value="form3">
      </form>
    </th>

[Blulagoon]

I am not entirely sure what you are doing with
action="<?php echo $editFormAction; ?>"

But with the code above, when the user clicks on submit all of the variables in your form will be available to the next PHP page as $_POST['County'] etc etc

You can use this in an sql insert statement:
$sql="INSERT into MyTable (County) VALUES ('".$_POST['County']."') WHERE .........";

You can also then go on to have a form on this page along the lines of:
<input type="text" name="County" value="<?PHP echo $_POST['County']; ?>">

which will fill in this field with the variable value.

HTH - Blu

[leob]

Thank you for the help.