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.

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

bpsdg wrote:
> 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.
>
>
>
>

SELECT LAST_INSERT_ID() FROM table_name

Norm

..oO(Ondøej Flídr - Sniper's softworks)

>You can use SQL command "select * from yourTable order by id desc limit
>1", which returns the newest record in table.

You know what a race condition is?

Micha