mysql slideshow

kclark

I am not sure whether to post on this category or another.

I have been able to get images from a form to a mysql db. there are multiple images that have the same id record, because I want to be able to have a slideshow that contains several pics related to the same record. What I don't know is how to get images (only the path stored in mysql) from the db to a slideshow where ID=ID. I can get the images to a page on my site, but the user has to click next for each image. I would like for the user to be able to watch the slideshow without clicking a button. Has anyone seen a script for this?

sneakyimp

i assume that button loads a url somewhere. you could put in a meta refresh tag:

assuming $url contains that url and $time_in_seconds is 5....do this:

  echo "<META http-equiv=\"refresh\" content=\"" . $time_in_seconds . ";URL=" . $url . "\">";

kclark

Here is my code that I have for my page (photos.php) that displays the images.

<?php require_once("config/include/utils.runtime6.php") ?>
<?php require_once("config/include/mysql.runtime6.php") ?>

<html>
<head>
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
<link rel="STYLESHEET" type="text/css" href="style.css">
<?php $photos = WrapMySQLDatabaseResults("album", "select * from photos where ID = " . $GLOBALS["ID"] . "", "block=2997","photos");
?>
<table width="200" border="1" cellspacing="2" cellpadding="0">
<? php $photos->MoveFirst(); ?>
<?php $photos->Move($photos->FirstRecordOnPage() - 1); ?>
<?php $rowCounter620 = 0; ?>
<?php while (!$photos->EOF() && $rowCounter620 < 999) { ?>
<tr>
<?php $cellCounter620 = 0; ?>
<?php while (!$photos->EOF() && $cellCounter620 < 3) { ?>
<td>
<div align="center">
<img src='<?php echo mapPath($photos->Value("file"), "photos/")?>' alt="" height="283" width="224" border="0"><br><?php echo $photos->Value("caption")?></div>
</td>
<?php $cellCounter620++; ?>
<?php $photos->MoveNext(); ?>
<?php } ?>
</tr>
<?php $rowCounter620++; ?>
<?php } ?>
</table>

Is this what you are asking for?

sneakyimp

I didn't ask for your code. I told you what HTML to output to force a page to load another page after a time interval. you should be able to figure it out.

kclark

Here is what I came up with.

<?php require_once("config/include/utils.runtime6.php") ?>
<?php require_once("config/include/mysql.runtime6.php") ?>
<html>
<head>
<?php $url = "photoform.php?ID=<?php echo $Obituary->Value("ID") ?>" ?>;
<?php $time_in_seconds = "5" ?>;
<meta http-equiv="content-type" content="text/html;charset=iso-8859-1">
echo "<META http-equiv=\"refresh\" content=\"" . $time_in_seconds . ";URL=" . $url . "\">";