Multiple Banner Ad Rotator?

I’d (actually it’s what we use for most clients) use phpAdsnew, which is an open source banner ad management system – it runs independantly, however it’s simple to insert the banners into your WP install/theme. we like it because it’s so easy for clients to manage thier own banner advertising, etc. see https://sourceforge.net/project/showfiles.php?group_id=11386

Try AdRotator plugin for WordPress. It is a simple WordPress plugin to rotate your banners randomly. You can use it in multiple locations on the same page with same or different set of banners.

ps. I forgot to mention the phpAdsnew plugin which works along with phpAdsnew within WP, found here:
https://blog.tassoman.com/wordpress-plugins/phpadsnew-integration/

phpAdsNew doesn’t really need any plugin. But it is rather complex to setup, though more powerful. So I suggested AdRotator which is fine for most purposes.

I have written a plugin to rotate banners in different positions in your blog, it’s called WPAds and you can check it out here.

Nick,

Great plugin! It works well on my https://www.amgmarket.com/amg/ site but I can’t get it working on another site.

For some reason, it can’t create the database tables and I get this error message in WP:

WordPress database error: [Table ‘mydatabase.wp_ads_banners’ doesn’t exist]
SELECT * FROM wp_ads_banners WHERE 1 ORDER BY banner_id ASC

I’m using a MYSQL server. I tried to check the permissions but don’t know enough about programming to figure it out, yet. Any recommendations?