Hi Jason, everything is working but I have had some people asking to get to the actual image in the power gallery from the random ones they clicked on in another page, at the moment I am just sending them to the gallery & then they find the image themselves.
I thought I could pass a url parameter but noticed that it doesn't have one, when viewing images in PG.
I have made another table that has the page URLs (pg1_galleryurl_grl) so I can get to the gallery, but how do I show the actual image they clicked on.
Below is the sql I am now using, as I said it all works fine I just need to get to the actual image
SELECT CONCAT(gallery_id,'/',file_prefix,'_782p.', file_ext) as fileName,pg1_gallery_images.description,pg1_gallery.title,description, pg1_gallery_images.file_ext, pg1_gallery_images.gallery_id, pg1_gallery.id, pg1_gallery.title, pg1_galleryurl_grl.galleryurl_grl
FROM ((pg1_gallery_images LEFT JOIN pg1_gallery ON pg1_gallery.id=pg1_gallery_images.gallery_id) LEFT JOIN pg1_galleryurl_grl ON pg1_galleryurl_grl.idgallery_grl=pg1_gallery.id)
WHERE gallery_id != '3'
ORDER BY Rand() LIMIT 2
Regards Chris :)