Recordset Help For Random Image From Galleries
Hi, can someone help with the sql for selecting a random image from the pg1_gallery_images table. Here is what I have so far but when I check the image properties in the browser I am missing some stuff. I just want to show a random image without the gallery itself. I can show the image I just need to get the correct path.
SELECT CONCAT(file_prefix,'.', file_ext)
FROM pg1_gallery_images
ORDER BY Rand() LIMIT 1
Thanks Chris