New record show follow number

[Copierbw]

A person is able to submit a query.
On page A the variables are sent to page B that shows him all the data entered and also does the entry into the database. That all works.
After the insert into the database I want to be able to retrieve his entry to display the autonumber field in the database which he will use as ref for any queries linked to his name. Must I do a Select statement after the Insert on the same page B to be able to show him his ref number? Thanks

You don't need eyes to see just the vision because there are always more ways and different answers to what we are used to...

 

[DRJ478]

You haven't told us what dtabase backend you are using.
MySQL has:

http://ca2.php.net/manual/en/function.mysql-insert-id.php

This tells you the last inserted ID.

 

[Copierbw]

I am using MySQL and thanks that method just made it a lot easier for me. I don't have a lot of users so I am not too concerned about someone else making a entry on exactly the same time...Thanks again...

You don't need eyes to see just the vision because there are always more ways and different answers to what we are used to...

 

[csniffer]

another entry cannot be made at the same time anyhow as each connection has its own ID number, each is handled separately. thats as far as i am aware anyhow.

To err is human, to completely mess up takes a computer.