On Saturday 06 July 2002 08:18, Matthew Nock wrote:
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?
If ProdID is an autoincrement field (and if it isn't you really should make it
so), then use mysql_insert_id().
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?
That's what you'll have to do if ProdID is not an autoincrement field.
--
Jason Wong - Gremlins Associates - www.gremlins.com.hk
Open Source Software Systems Integrators
* Web Design Hosting * Internet Intranet Applications Development *
/*
Someone's tie is caught in the printer, and if anything else gets printed,
he'll be in it too.
*/
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
