I
have an inset command such
as
insert (name)
values($name);
I have
id column as autoincrement. How can I get the id of the inserted record
after inserting.
class="normal">Answer
insert (name)
values($name);
SET @lastid = LAST_INSERT_ID();
select
blah_blah from table where id =
@lastid;
To get that
back into php, you do a normal mysql select on it like
this:
select
@lastid;
No comments:
Post a Comment