I am not entirely familiar with php and am trying to display an image on my site from a recordset which will reload every several seconds with a fixed(set) image. Example: Random image from rs (time delay) set image (time delay) Random image from rs etc..
Currently I have the following code that is working well for displaying a random image however I want to change 2 things with it 1) as it is it only alternates on page refresh, so how would i make it alternate every several seconds? 2) How would I make it reload to a set image and alternate with an image from the database?
Code: Select all
SELECT ImageFile rand() as random_number
FROM clublistingpics
ORDER BY random_number DESC LIMIT 1