database output each line on each page : <p>i am trying to put data of each each from my database to each page by modifying it on each page</p>

<p>for example i have on my database with table of :</p>

<p><code>id   fname   lname   age
 1     bob     carl   23
 2   michael   jake   25</code></p>

<p>now i want each line to show up on each page i want</p>

<p>for example i have
page1.php this must out put the first line like this
<code>bob     carl     23</code></p>

<p>and i have page2.php this must out put the second line like this <code>michael   jake   25</code></p>

<p>and so on.</p>

<p>i have a code like this</p>

<pre><code>$sql = "SELECT * FROM pages";
$results = mysqli_query($connection,$sql);

if (mysqli_num_rows($results) &gt; 0) {
    while ($row = mysqli_fetch_array($results)) {
        $id = $row["id"];
        $pname = $row["pname"];
        $pimg = $row["pimg"];
        $pstream = $row["pstream"];
    }
}
</code></pre>

<p>if i echo this out it is gonna output the last line only or with while loop it's gonna output all lines on one page. how can i mark from my code which line should be showing ?</p>
