Re: Retrieve value of newly inserted row.
| From: | Robert Cummings | Date: | Wed, 14 Feb 2007 18:31:22 +0000 |
| Subject: | Re: Retrieve value of newly inserted row. | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-248876@lists.php.net to get a copy of this message | ||
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. |
`------------------------------------------------------------'