Slideshow

[kelly22]

Hiya

My pictures are stored on a mysql database.
I have an automated query where it selects all the pictures with the same $id and display all after each other. If you click on a picture it appears big in a new window, but you have to click on each one seperatly so that it appears big.
Any chance anyone could tell me how to build in a button into the opened picture to continue to the next one?

The code i have for the query is

$sqlab = "SELECT * FROM events order by sortierdatum_timestamp DESC";
$res = mysql_query("$sqlab");
$num = mysql_num_rows($res);

if ($num > 0)

//Daten auf dem Bildschirm ausgeben
//Tabellenbeginn
for ($i=0; $i<$num; $i++)
{
$j = mysql_result($res, $i, "jahr");
$d_t = mysql_result($res, $i, "sortierdatum_timestamp");
$z = mysql_result($res, $i, "zeit");
$li = mysql_result($res, $i, "link");
$id = mysql_result($res, $i, "id");

$datum = date("d.m.y", $d_t);

echo "<a class=klein href=right_aktivitaet.php?key=$id target=mainFrame>$datum</a><br>";

			}

hope anyone can help me as to be honest i have no idea from php/mysql

Thanks

[cretaceous]

It's much less trouble to do the image swap with javascript.
Try jquery cycle or galleriffic - both those will give you image cross fades, thumbnails and (optional) automated slideshows.
Cycle provides lots of wacky transitions as well

[sneakyimp]

I'm guessing that the file right_aktivitaet.php[/b[ just uses $_GET['key'] to determine which images is to be shown.

It should also run
a) a query to fetch the one image (if any) preceding the current image and put the id in $previous_id
b) a query to fetch the one image (if any) following the current image and put the id in $next_id

Then, it's simple. rather than just outputting the <img> tag to show the current image, you also output a previous link which links to right_aktivitaet.php?key=$previous_id and a next link which links to right_aktivitaet.php?key=$next_id.

If either $previous_id or $next_id are blank, you skip the corresponding link.

[kelly22]

thanks for the help. Managed to do it now.