HI Friends, I tried: I inserted a row in mysql using php in the first webpage and second webpage i tried to retrieve it. I got: But in the next page i did not get the lastely inserted row. When inserted the another row, i was able to get the first inserted row and not the lastest row. So every time i miss the last inserted row the first time and when then i was able to get it as soon as i insert another row. How to solve this issue? Is it something related to commit i am missing here?
I believe MySQL has instituted optimization procedures that delay commits. This maybe what you are seeing. Q...
you need to post more info like piece of code and what exactly queries you using, I faintly guess you are relying on something like "last_insert_id"...
Yup, your script might be the problem so show as what you've done. If not, try with COMMIT command after every insertion