Problem in fetching rows from mysql in php?

[JackyRock]

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?

[simran10101]

To resolve this pbm I need code.

[lokeshm]

I suggest you make use of mysql_insert_id() function.

Whenever you insert a record, you can get the value stored in the AUTO_INCREMENT column of the last inserted record by calling the mysql_insert_id() function.

[svishnu]

just try

<?php
//obtain connection
 $query = "SELECT * FROM Table";
$result = mysql_query($query);
if(!$result){

}
?>

[svishnu]

<?php
//obtain connection
$query = "SELECT * FROM Table";
$result = mysql_query($query);
if(!$result){
    die mysql_error();
}
else{
    while($row = mysql_fetch_assoc($result)){
         echo $row['rowname in table'];
        
    }
}
//close connection
?>

so you will get all rows