foreach函数不会正确显示我的数据库值

here is my code for each it dosent shows all db values except last one;

<?php
        foreach($result as $query2)

                    echo '<tr>'; 
        echo "<td>" . $query2['firstname']. "</td>";
        echo"<td>".$query2['username']."</td>";
        echo"<td>".$query2['firstname']."</td>";
        echo"<td>".$query2['lastname']."</td>";
        echo"<td>".$query2['gender']."</td>";
        echo"<td>".$query2['email']."</td>";
        echo"<td>".$query2['mobile']."</td>";
        echo"<td>".$query2['address']."</td>";
        echo "<td><a href='http://localhost/service/change.php?edit_id=".$query2['uid']."'>Edit</a></td>";
        //echo"<td><a href="http://localhost/service/change.php?edit_id= ".$query2['uid']."">Edit</a>
        //<a href="http://localhost/service/delete.php?delet_id=<?php echo $query2['uid']?X</a></td>
                    echo "<td><a href='http://localhost/service/delete.php?delet_id=".$query2['uid']."'>x</a></td>";
          echo '</tr>'; 


        ?>

use key- value reference for that....

foreach($result as $key=>$value)
{
  echo "<td>" . $value['firstname']. "</td>"; 
  echo "<td>" . $value['lastname']. "</td>";
}