PHP Show next image in the table
<p>I am showing an image on my page from the db table like this:</p>

<pre><code>&lt;?php
if ($db_found) {
$SQL = "SELECT * FROM myTable where id='$posted_id'";
$result = mysql_query($SQL);

while ($db_field = mysql_fetch_assoc($result)) {

echo '&lt;img src="images/'.$db_field['image'].'" alt="" /&gt;';

}
mysql_close($db_handle);
}
?&gt;

&lt;a href="#"&gt;Next&lt;/a&gt;
</code></pre>

<p>How can I do so that if $posted_id is for example 1 ... when I click the "Next" link the image id = 2 appears and so on.</p>
