Page 1 of 1

Cycle fixed image with random image?

Posted: Mon Dec 15, 2008 10:01 pm
by melost
Hi All,

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
Thanks to anyone that can offer advise with this.

Re: Cycle fixed image with random image?

Posted: Tue Dec 16, 2008 6:52 am
by maneetpuri
Hi,

AJAX is the answer or you can even do it using XML & Flash.

Cheers,