Howdy - I wonder if there is an more efficient way to do the following: I have 2 tables -
The user submits a new record into table A and an id (primary key) is created using the auto-increment. At the time that the new record is created in table A I need to insert the newly created id from table A into a column in table B. Is there a way to do this without performing multiple queries to either table? Any help is appreciated Thanks Mark sql,query --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
