In my 468x60 banner rotation system (AdPeeps), i've created zones for each LinksSQL category. Now cannot find a way to assign these zones to different categories in LinksSQL.

For example, i'd like to place banners with cars in Auto/Moto categories, banners with jewelry in jewelry category and so on.

How do you solve the problem? Need your help again :(

I'm not sure what the ad code for Adpeeps is like. I use phpAdsnew and it can serve targeted ads pretty simply.

In the ad invocation code there is a field for keywords that I populate using the meta keywords field for the category. In the adserver admin banners can be assigned keywords as well.

So if the category has a keyword called 'computers' and the ad has the same keyword, then that is a match and the add displays. Hope that helps you get started.

Thank you for your help, aus_dave, but this is not an option for me :(

Is there another way to identify categories and put targeted ads into them?

Any other ideas?

What about adding a new field to the Category table which contains the related value for your ad zone. Then you should be able to just show the advert in the template. If you let me know what you would use to show the advert normally I'll try to modify it for you.