Retrieving unique id after new row has been inserted

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
amdorsey
Forum Newbie
Posts: 19
Joined: Mon Dec 06, 2004 2:46 pm

Retrieving unique id after new row has been inserted

Post by amdorsey »

I am inserting data into a table, after the INSERT RECORD has been completed, I want to send an email notifying a user of the insertion. I want to display the ID of the new row inserted.

How do I pull the ID right after the row has been inserted to sen via a senmail.php script?

Any Ideas?
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

Post Reply