use a hidden variable in each form to tell which action to do.
i.e. each separate form embed this.
<form name="products" method="post" action="$php_self">
<input type="hidden" name="form_number1" value="form1_action">
<input type="submit" name="Submit" value="Submit">

then do an if to decide which form was submitted and what action to perform.

if ((isset($HTTP_POST_VARS["form_number1"])) &&
($HTTP_POST_VARS["form_number1"] == "form1_action")) {
        update my databases1

if ((isset($HTTP_POST_VARS["form_number2"])) &&
($HTTP_POST_VARS["form_number2"] == "form2_action")) {
        update my databases2



-----Original Message-----
From: Michael Knauf/Niles [mailto:[EMAIL PROTECTED]]
Sent: Monday, December 09, 2002 1:59 PM
Subject: [PHP-DB] How do I... (update one table from one page which
displays multiple editable tables)?

I have a simple form that displays the values of some fields in a  table so
the user can edit those values and update the database. (mySql) the form
action is $php_self, and it triggers an update query that I haven't written
yet, because on the way there, I hit a small snag that I hope you can help
me with.

You see, I want to put 8 r 9 forms on the same page, each with the ability
to update one table within the database... but how can I tell which form
the user wants to change?

If my head was screwed on straight about this, that question might be more
comprehensible, but here's the code for the form, in case that clarifies

$id ="445"; //fixed value for testing
$productsQuery ="SELECT id, fgNumber, productName, productDescription FROM
products where id =$id";
$productsRecordset = mysql_query($productsQuery) or die(mysql_error());
<form name="products" method="post" action="$php_self">
<table width="100%" border="0" cellpadding="10" cellspacing="0" bgcolor="
                        <td colspan="4">Products Table</td>
                        <input name="productId" type="text" id="productId"
value="<? echo $productsRow['id'] ?>" size="5"></td>
                                    <input name="fgNumber" type="text" id
="fgNumber" value="<? echo $productsRow['fgNumber'] ?>" size="10"></td>
                                    <input name="productName" type="text"
id="productName" value="<? echo $productsRow['productName'] ?>" size
                                    <input name="productDescriptiion" type
="text" id="productDescriptiion" value="<? echo $productsRow
['productDescription'] ?>" size="48"></td>
                        <td colspan="4">Update Product Information
                        <input type="submit" name="Submit" value


PHP Database Mailing List (
To unsubscribe, visit:

PHP Database Mailing List (
To unsubscribe, visit:

Reply via email to