4 replies to this topic

[shikha985]

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?

Edited by Orjan, 09 March 2010 - 01:25 AM.
Removed spam

[WingedPanther]

What is your table structure? Do you have an indicator of when something was added?

[joyo]

I also don't know this problem , I want to know the reason too.

[abdul.gafur]

if you use a primary key that auto increment, you can get the last row with
"select * from yourtable order by yourid desc"

[joyo]

abdul.gafur said:

if you use a primary key that auto increment, you can get the last row with
"select * from yourtable order by yourid desc"

good, also you can append " LIMIT 1" to the sql script , it would imporve the Execution efficiency.