Re: [PHPwestoz] getting the last inserted id in mysql

[Samuel Cochran <sj26@sj26.com>]

Evan Barter wrote:

> Samuel Cochran wrote:
>
> > Mike Fewings wrote:
> >
> > > > Unfortunately I don't know any function in MySQL that lets you 
> > > > retrieve the auto-increment ID of a field you just created. You 
> > > > normally have to do another select, which is not hard if you do 
> > > > this: "SELECT ID FROM Artists ORDER BY ID DESC LIMIT 1" This will 
> > > > give you the last created ID, which normally would be the last 
> > > > record you created.
> > >
> > >
> > > This function can retreive the last insert id from the database
> > >
> > >                select last_insert_id() as feild_id
> > >
> > > and make this query immediately after the insert and it will return 
> > > the last id that was inserted by auto increment.
> >
> > Alternatively, one can use the mysql_next_id() function of PHP. Have 
> > a look: http://php.net/mysql-next-id
>
> There's always mysql_insert_id() 
> (http://au.php.net/manual/en/function.mysql-insert-id.php). But now 
> I'm just being redundant. :)

That's what I meant :$

-- Sam