Posted by Richard on 07/15/07 16:10

"bpsdg" <bpsdgnewsBRAKE@tiscali.nl> wrote in message
news:469a17e1$0$37725$5fc3050@dreader2.news.tiscali.nl...
> Hi,
>
> I'm using Dremweaver MX 2004.
>
> I've just started into PHP / MySQL, but it works pretty well up until now.
>
> One thing I can't seem to figure out at the moment.
>
> I have a details (display only) page, which show one record. On that page
> I
> have buttons for new-, update- and delete record. I got the update record
> page working, so that after updating it will go to the same record on the
> details page using an ID field.
>
> I want the same behaviour from the insert record page. But the ID field is
> an autoincrement field and I don't know how to get that when the new
> record
> is created. In visual basic for example I can grab the new auto increment
> field just before the record is created. But I can't find anything like
> that
> in PHP. It can't always just be the highest number, because maybe two
> users
> are adding records simultaneously.
>
> Any suggestions?
>
> Regards, Bas.
>

Hi Bas,
see:
http://nl3.php.net/manual/en/function.mysql-insert-id.php

Regards,
Richard.

[Back to original message]