Data assist rotate/random display of content
been trying to find a solution to randomise the content of data assist for images/banners.
so far I am using a simple rand but the pages load so darn slow its impossible, other solutions that i have found would mean changing alot of the coding and im not that experienced in php to do so, hence the extensions.
so far i have this:
$query_WADAsitebanners = "SELECT banID, banDate, banSupplier, banProfile, banLink, banLoc FROM sitebanners WHERE banLoc='CenterPage' ORDER BY RAND() ";
have also tried this with a limit 0,1 and limit 1, the above actually randomises better.
Please help.
thanks in advance