No, you have to use two queries to do two inserts into different tables...
---John Holmes... > -----Original Message----- > From: Noodle Snacks [mailto:[EMAIL PROTECTED]] > Sent: Thursday, October 10, 2002 7:07 AM > To: [EMAIL PROTECTED] > Subject: [PHP-DB] Re: Multi-Table Insert and gettin' data from auto-inc > coloumn in one to the other > > I can get the previous insert auto-increment id via mysql_insert_id(). it > will solve my problem. but if you know a soloution that will work in one > query please share it with me/everyone! > > > -- > JJ Harrison > [EMAIL PROTECTED] > > "Noodle Snacks" <[EMAIL PROTECTED]> wrote in message > [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 > > [EMAIL PROTECTED] > > > > > > > > > > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
