Thread: Problem in fetching rows from mysql in php?

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?




thanks................
.........................

very interesting question but I don't know about this if I get any suggestion I will post here dude


Thanks nice to meet you

Does your database table have a primary key, or at least a field with a a unique index? If not, you have no way to specify the particular record you want to retrieve.

Also, how are you doing the insert? INSERT INTO will always add a new row, which I believe is what you want, but if the record you are inserting has no unique field, then when you try to get the record you will always get the first row in the table.

I believe MySQL has instituted optimization procedures that delay commits. This maybe what you are seeing.

Q...

I personally feel that the problem is basically because of database tables or unique index. If not applicable then you have to specify records you need to retrieve.

the index/records dont add. what php version are you using?