Inserting records across multiple mySQL forms - tracking ID's?
| From: | Matthew Nock | Date: | Sat, 06 Jul 2002 00:18:03 +0000 |
| Subject: | Inserting records across multiple mySQL forms - tracking ID's? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-20351@lists.php.net to get a copy of this message | ||
I want to create a form that will input a number of records, into a number
of different tables.
The first part of the detail will need to create a new "product" record.
this will create Product ID. the Product ID is required to insert the
"features" for this product ID into another table.
Is there any way that run determine the ProdID of the record I am inserting,
so that I can run the insert for the features?
or am I going to need to Insert the Product record (to get the Product ID),
and then query the product database, to get the new ID, then use the newly
gained ID, to add all the features to the feature table?