Unanswered: Getting the Result of an previous INSERT Statement
I've got a problem and have no solution on it.
I've written a script which writes data in a mysql table nd i want the result of this statement to work with it.
First I wanted to send an SELECT statement directly after my INSERT statement. It's possible because every entry in my table has an id wich is auto_increment. So i could sort it by the highest number and that my result.
But I think it's problematic when more than one user work on the same table because my SELECT statement has du be executed directly after my INSERT statement. Because when another user sends also a INSERT statement for the same table it could be possible that these statement is executed between my own SELECT ans INSERT statement, isn't it? In that case i would get the wrong result.
So long description for a short question: How do i get the result of an INSERT statement before any other statement is executed?