Slideshow help using MYSQL and PHP

jeffafd

I have a couple of websites sharing a database with about 1000 images in different categories, all images are stored in one directory.

One of these websites I would like to add a slideshow of the images using only 1 of the categories from the database. The present website - USHotBabes.com is already sorting properly and from each image you can go to the "previous" or "next" image, but what I would like to add is either each image page can automatically go to the next after so many seconds or the user can start a slideshow manually, but I'm not sure how to go about doing this.

I have seen some javascripts that will do this but I think they all need to be hardcoded with each image.

Can I add a snippet to my existing page to automatically climb to next image?

Any suggestions would be appreciated.

maxpup979

<meta http-equiv="refresh" content="10;url=http://url/nextpage">

should work for what you have described. You can use php to determine what the next image should be based on whatever criteria you need.

jeffafd

Thanks Maxpup - the following script worked, except it does not stop at the end, it continues on randomly pulling things from the database (items, calendars, but not images)

Here is the edited script that works -

<meta http-equiv="refresh" content="5;url=slideshow.php?id=<? echo "$rown"; ?>">

Here is the query running prior to the refresh -

$query = "SELECT id FROM images WHERE category = '$category' AND id > $id AND approve != 2 ORDER BY id ASC LIMIT 1" ; // For Previous 
$result = mysql_query($query); 
$numrows2 = @mysql_num_rows($result); 
$rown = @mysql_result($result,0); 
$query2 = "SELECT id FROM images WHERE id < $id ORDER BY ASC LIMIT 1"; // For next Record

If you want to take a look at what is happening, the last image is id-1056

But I'll send you to id - 1054 so you can see what I mean, everything after 1056 is not images they belong to items for sale, such as clothes, calendars, etc...

http://ushotbabes.com/slideshow.php?id=1054

jeffafd

Well after more tweaking it now works pretty good.

There are a couple of things I would like to add

Start/Stop buttons
Center popup on screen

So any help is appreciated...

Here is the script so far:

<?php 

// Display Record 

$query = "SELECT id, title, category FROM images WHERE category LIKE 'SexyWomen' ORDER BY RAND() LIMIT 1" ; // For Previous 
$result = mysql_query($query); 
$numrows2 = @mysql_num_rows($result); 
$rown = @mysql_result($result,0); 
$query2 = "SELECT id, title, category FROM images WHERE category LIKE 'SexyWomen' ORDER BY RAND() LIMIT 1"; // For next Record 

echo "<center>"; 

?> 


<?php

if(empty($id)) { // no rows returned 

// what to do if no rows returned 

}else{ 

?> 

<meta http-equiv="refresh" content="3;url=slideshow.php?category=<? echo "$category"; ?>&id=<? echo "$rown"; ?>">

<?php
}
?>

You can now access the slideshow from every page of the website, using the left navigation - "View Slideshow of Images "

USHotBabes.com