I'm just playing around with your FANTASTIC gallery (I'm very very impressed with it). I'm looking at using it for an ID Parade page that I have on my site. Its just a collection of photos that people have sent me.
My question is this...
I would like to be able to display one random pic on the front page of the site with a link along the lines of "Have a look at the ID Parade" and then a pic.
How do I access the database to extract one picture from it ? I'm no expert with php and sql but I'm not a complete newbie either. I can connect to the database etc but what query do I need to run and on which table in order to get a random picture ?
Any help is greatly appreciated.
Cheers
JT
PS. Keep up the excellent work with the script :wink:
do a search for ssi.php
Thanks for the advice but you could you expand a little ? Do a search where for ssi.php ? On Google or on this site ? I've searched on this site and found a similar problem posted by someone else and they were attempting to resolve it. The admin said something about anycontent.php ??
Could you give me a bit more info please ?
My main page is a .php file and I just want to add a random picture from my database (ie. out of the coppermine database) into a table.
What would the query look like ?
Any help much appreciated.
Thanks :)
Don't mind me, I'm just babbling on about a module that I just remembered we don't suggest using anymore. :) SInce you know something about php, go look at the code for the random picture block. You'll see how to construct the query. :)
Okeedokee, will do. Thanks for your help matey.
Keep up the good work with the gallery.
Cheers
JT :lol: