Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other
| From: | Noodle Snacks | Date: | Thu, 10 Oct 2002 11:00:05 +0000 |
| Subject: | Multi-Table Insert and gettin' data from auto-inc coloumn in one to the other | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-22312@lists.php.net to get a copy of this message | ||
I have table A with an auto increment coloumn called tid. during the same
query I need to get that value and stick it in a related record in anouther
table.
I have two doubts.
A: What is the way to do a multitable insert? guess is: INSERT INTO
table(fields) VALUES (fields), table1(fields) VALUES (fields) etc... is it
even possible in one query?
B: how can I get the auto increment value from one into the record on the
other table?
--
JJ Harrison
lizner2002@yahoo.com.au