Re: [PHP] Retrieve value of newly inserted row.

[Arpad Ray]

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 
value
in 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