Getting MySQL Generated Keys

[thehuby]

Hi,

I am a Java/JSP developer by trade but am currently developing a
MySQL/PHP solution.

In JSP when I run an INSERT statement on the db I am able to
automatically get back a list of any generated keys (without having to
do some sort of subsequent query to get the information).

Is there a PHP equivilent of this?

Thanks

[Chris Hope]

Re: Getting MySQL Generated Keys

thehuby wrote:
[color=blue]
> I am a Java/JSP developer by trade but am currently developing a
> MySQL/PHP solution.
>
> In JSP when I run an INSERT statement on the db I am able to
> automatically get back a list of any generated keys (without having to
> do some sort of subsequent query to get the information).
>
> Is there a PHP equivilent of this?[/color]

Unfortunately, as with all built in PHP database functions, there's no
database abstraction layer built into PHP which will do it for any
database, but for mysql you can use the mysql_insert_id () function.

http://www.php.net/mysql_insert_id

--
Chris Hope | www.electrictoolbox.com | www.linuxcdmall.com

[thehuby]

Re: Getting MySQL Generated Keys

Cheers Chris that worked a treat!

Rick
<a href='http://www.e-connected.com'> Accessible Web Design by
eConnected</a>