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 lizner2002@yahoo.com.au "Noodle Snacks" <webmaster@tececo.com> wrote in message 20021010105833.4424.qmail@pb1.pair.com">news:20021010105833.4424.qmail@pb1.pair.com... > 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 > > > > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php