Retrieve image from DB with Next/Prev buttons

[vinsbg]

Hello,
I'm kinda new to php and still earning.
So I have upload form wich uploads image to foldar and save name to database(mysql). So far i have this:

    $sql="select * from images order by ID ASC LIMIT  1, 1";

$result = mysql_query($sql) or die (mysql_error());

while($row = mysql_fetch_assoc($result)){
      echo "<div id=\"picture\">";
      echo "<p>";

      echo "<img src=\"upload/" . $row['filename']  . "\" alt=\"\" /><br />";
      echo $row['caption'] . "<br />";
      echo "</p>";
      echo "</div>";

How can I change the code to show me one image at the time.. Like sort of gallery with buttons 'next' and 'prev' to change images?
In DB I store 'id', 'caption' and 'filename'.

[NogDog]

Search on something like "PHP pagination" if you don't feel like waiting for an answer here. (I'm just doing a drive-by to see if any forum spam needs removing. 🙂 ) Basically, you'll want to configure the pagination links to send a value via $_GET that you'll use as the OFFSET value in your SQL.