next »

[TechnicalTalk]

 TechnicalTalk » Programming and Web Development » PHP
 Problem in fetching rows from mysql in php?

[JackyRock]

JackyRock  

 Problem in fetching rows from mysql in php?

HI Friends,
I tried:
I inserted a row in my sql using php in the first web page and second web page i tried to retrieve it.
I got:
But in the next page i did not get the latest  inserted row.
When inserted the another row, i was able to get the first inserted row and not the latest 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 to remove personal promotion. we only allow promotions through signatures ***

[Admin]

Admin  

 Re: Problem in fetching rows from mysql in php?

If you are using some ID field/column in the table then you can make it as primary key and can set auto-increment property on that ID column. The auto-increment property on the column will make that column to have highest ID number. But for this you will need to have Data Type of the ID column as integer. So now, every time you insert a new row into the table, you can fetch the latest row by this ID column using a query:

Select MAX(ID) from table_name

Here the MAX(ID) will be the highest ID number in the table and therefore the latest row in the table.


There is one another way to achieve this, if you do not want to use ID column. You can use some Date filed/column in the table which will store the date and time at which the row is inserted in the table. So in this case, the row with the latest date will be the latest row in the table.