How do I... (update one table from one page which displays multipleeditable tables)?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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

<?
$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());
$productsRow=mysql_fetch_array($productsRecordset);
?>
<form name="products" method="post" action="$php_self">
<table width="100%" border="0" cellpadding="10" cellspacing="0" bgcolor="
#CCCCCC">
            <tr>
                        <td colspan="4">Products Table</td>
            </tr>
            <tr>
                        <td>ID:
                        <input name="productId" type="text" id="productId"
value="<? echo $productsRow['id'] ?>" size="5"></td>
                        <td>FG#:
                                    <input name="fgNumber" type="text" id
="fgNumber" value="<? echo $productsRow['fgNumber'] ?>" size="10"></td>
                        <td>Name:
                                    <input name="productName" type="text"
id="productName" value="<? echo $productsRow['productName'] ?>" size
="36"></td>
                        <td>Description
                                    <input name="productDescriptiion" type
="text" id="productDescriptiion" value="<? echo $productsRow
['productDescription'] ?>" size="48"></td>
            </tr>
            <tr>
                        <td colspan="4">Update Product Information
                        <input type="submit" name="Submit" value
="Submit"></td>
            </tr>
</table>

Michael


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux