Jump to content


This topic is now archived and is closed to further replies.


Image slideshow woes...

Recommended Posts

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!

    $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);

<? 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>


Share this post

Link to post
Share on other sites
Try to :

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

Share this post

Link to post
Share on other sites


Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.