Dan Shirah wrote:
On my second insert statement, please note "credit_card_id". This is an auto_increment column in table1. What I need to do is pull the value of"credit_card_id" from the newly inserted row from insert1 and put that valuein a variable to assign it to "credit_card_id" in insert2.
Just append "; SELECT @@identity" to the first query, then fetch the result as normal.
Arpad -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
