Image slideshow woes...

[ching-a-ling]

Hello everybody!

Ok, here is my problem. I want to make a slideshow sort of page, where a user clicks on a thumbnail from a photo gallery and a window pops up that shows the image and "next" and "previous" buttons. I am having so much trouble with this! The image data is stored in a database, and the problem is that I can't figure out how to load the two images that are [i]nearby[/i] the current image. The code I have so far is below. Thank you so much!



[code]
    $current_pic = mysql_query("SELECT image_path FROM pictures WHERE id = '$id'");
    $pix = mysql_query("SELECT id FROM pictures WHERE category1 = '$cat' OR category2 = '$cat' OR category3 = '$cat' AND id != '$id'");
    $img = mysql_result($current_pic, 0);
    $next = mysql_result($pix, 0);
?>
[/code]


<? if($prev){ echo "<a href=\"$PHP_SELF?id=$prev&cat=$cat \"><img src=\"previous.gif\" border=\"0\"></a>"; } ?>
<a href="<? echo "$PHP_SELF?id=$next&prev=$id&cat=$cat"; ?>"><img src="next.gif" border="0"></a>
</div>

</body>
</html>

[poirot]

Try to :

1. Modify AND id != '$id'"); to AND id < '$id' LIMIT 1") for previous.
2. Same thing for next, but use id > '$id'