I am using ajax to run a php/mysql insert into query. That works fine.
What I now want to know is what is the best way to capture the id of the record that I have just entered.
I was thinking of running:
Select max(id) from table1
immediately after the insert into. Will that be ok or will there be conflict in the odd change that two person enters a record at the same time?