On Wed, 2007-02-14 at 13:26 -0500, Robert Cummings wrote: > On Wed, 2007-02-14 at 13:20 -0500, Dan Shirah wrote: > > Hello, > > > > 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 value > > in a variable to assign it to "credit_card_id" in insert2. > > Search the web for last_insert_id()
Never mind, just noticed you are using MS SQL. Cheers, Rob. -- .------------------------------------------------------------. | InterJinn Application Framework - http://www.interjinn.com | :------------------------------------------------------------: | An application and templating framework for PHP. Boasting | | a powerful, scalable system for accessing system services | | such as forms, properties, sessions, and caches. InterJinn | | also provides an extremely flexible architecture for | | creating re-usable components quickly and easily. | `------------------------------------------------------------' -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
