Forum Moderators: coopster
$query = "SELECT * FROM table WHERE image = '".$number."'";
$query = mysql_query($query);
While ( $img = MySQL_fetch_array($query) ) {
$url = $img['img_url']; // this is where the image is located(the URL)
$number = $number + 1; //adds 1 so you can find the next picture
echo "<img src=\"{$img}\">";
echo "<a href=\"image.php?number=$number\">NEXT</a>";
}
This will inturn, go to page.php?number=2 and will get image 2