orderby=ID&order=ASC
should be
orderby=random
Thread Starter
Doug99
(@doug99)
thank you for the quick response. I apologize, I did use the random, then I experimented by using the other attributes as well, just happenened to have used ASC at the moment I was typing my email to you.
I did change the code to what you specified. It still does not work.
When I try the different attributes, like, ID asc or des, it works on the initital ad, but the ad does not change when the screen is refreshed, regardless of the attribute used.
One caveay- perhaps the problem is that I am building the site on utliizing the subdomain available at WP-Engein, for example, doug.wpengine.com/admin.
so the site is not “live” but in a subdomain development environment. Do you think this has anything to do with not adchange, regardless of ad change type specified.
feel free to take a look at http://doug.wpengine.com/
here is the code i used after getting your response….
http://doug.wpengine.com/
would be happy to send some money your way for your time on this.
Thread Starter
Doug99
(@doug99)
I think you may be interested in knowing what the problem was for future customers of yours who are using wpengine for hosting.
I have fixed the problem, by accident. WPengine emailed me a week ago that they planned to do the update to wp 3.6 on myaccount today.
I checked my site’s wpengine admin screen to see if they had done the upgrade yet. they had not. However I did notice a little box on that screen in which said:
Allow ORDER BY RAND()
Normally we disable ORDER BY RAND() orderings in MySQL queries because this is a big no-no for large databases which we’ve seen cause massive slow-downs for dozens of our customers. However, you can enable it if you know what you’re doing, for example if you cache the results for 5-15 minutes so that you’re not pummeling the database with these slow queries.
By default, the box was checked no. I changed it to yes, and immediately the ads were working.
So, your wpengine hosting customers will have this problem in the future if they are unaware of that box, as was I.
Thank you for your time….
