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
