More Banners

The INSERT command is run in the Tools ... Install SQL Patches ...

Ajeh:

The INSERT command is run in the Tools ... Install SQL Patches ...

Thanks!! Sorry for being so newbie
enzo

Not a problem ... glad to hear you are getting into the swing of things ... :smile:

Ajeh:

Not a problem ... glad to hear you are getting into the swing of things ... :smile:

I have used your code for all2, but also I edited it for two more boxes right_banner and left_banner. Aaaaaand it works!!!
thanks alot
enzo

UPDATE:

ahaynes101:

not sure if you ever got this going but I may have a solution for you.

Ajeh's advice was on the money with one extra thing that is easily overlooked that, when not changed, will not allow you to add new group names to the drop down in banner manager, nor see the sidebox banner in your store.

In your database table for "banners" there is a limit on the number of characters that can go into the field for "banners_group". By default it is limited to 15 characters "varchar (15)".

If you edit that to the number that you need, (20) worked for me, you can add the group name and see the banner.

The best way to edit that number, for me, was to log into your hosting control panel, go to MySQL - phpadmin , find the table called "banners" then find the field called "banners_group" and look to edit the value for VARCHAR in that field.

hope that helps! I have learned a great deal just by reading these forums it feels good to give back!:smile:

I suppose that update was for Ruzzell, not ahaynes.