galahad

I'm trying to set up a Javascript slideshow but with images that are pulled from a mYSQL database using PHP.

For example:

- and so on, with a statement testing to see if an image exists in that field. If it does, it gets added to the page with all the images displayed as thumbnails.

What I want is to have the images bring up their larger version when hovered over, and launch a slideshow with an autoplay feature as well as the usual back / next / play / stop controls etc.

However all the slideshows I've seen (Javascript based) have the image names assigned manually to individual variables in the page header.

The problem being that my images are being generated by the PHP call to the database.

Anyone know how I can get a Javascript slideshow working within this context- or know of one which actually does work with PHP?

(I was using Lightbox, which is great, except that the client doesn't like it so I can't use it...)

L Plates

Have javascript operate as php using htaccess and insert images into javascript with a php call

__________________
There is a very fine line between "hobby" and "mental illness."

North Wales Web Design
dbPoker

crispibits

If I understand you correctly, you could use an Ajax call to your server asking for a list of images. Format the return as a JSON object:
"['foo.jpg','bar.jpg']"

You can then use something like prototype.js and it's handy .evalJSON() method to parse that into a Javascript array:

var imageArray = returnedValue.evalJSON();

imageArray[0] is foo.jpg
imageArray[1] is bar.jpg

You can now use that array for your slideshow.
Hope that makes sense!
Cheers,
Crispin