I am having a similar problem ..
I have set up 5 banners and it appears to be stuck on the 4th and 5th banners....
Odd. .
I found I had to have RAND() not RAND(NOW()) as the latter did not seem to work when I put the following query inth mysql cmd line interface..
SELECT * FROM ads ORDER BY RAND(NOW());
Yielded the ad list in the same order EVERY time
SELECT * FROM ads ORDER BY RAND();
Yielded the ad list in a different order every time.
|