Posted by Ond�ej Fl�dr - Sniper's softworks on 07/15/07 13:03

bpsdg napsal(a):
> 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.
>
>
>
>
You can use SQL command "select * from yourTable order by id desc limit 1", which returns the newest
record in table. It should works if your application doesn't have so many request for inserting new
line at one time.When your application will generate more lines between inserting and selecting new
ID, you should use transaction in mysql and lock table for inserting.

Regards
OF

--
S pozdravem
Ondřej Flídr - Sniper's softworks
+420 776 167 963
ICQ: 248 888 883
Skype: snipers-softworks
flidr@snipers-softworks.net
http://www.snipers-softworks.net

[Back to original message]