Hey all,
Our newspaper has a restaurant directory for the city we report in, and we're building a restaurant directory. What I've done is made a content type called "Locations" and used taxonomy to identify different locations as venues, restaurants, etc...
In this case, I've set up a view that will only show locations tagged under "restaurants".
I've also set up taxonomies such as "price", "geographic zone", and "cuisine". These are used as filters and are exposed in the view, so that users can select from a drop down what they're looking for. So if somebody wants to see all restaurants under "Cajun" it will only show Cajun restaurants. They can also combine these filters. Somebody could select "Cajun" and "Between $10 and $20" and it would only show those restaurants.
Now, here's my problem: We have restaurants that advertise with us, and they buy banners that go on the top of certain landing pages we've set up (so if somebody goes to the "Cajun" landing page, a restaurant's ad resides there at the top). What I'd like to be able to do, is that when people select "Cajun" from the drop down in the view, it would show the ad for the Cajun restaurant. Ditto for other drop-downs selected.
I was hoping the Ad module would have some sort of solution, but it doesn't seem to have been developed that far (http://drupal.org/project/ad_views).
Does anybody have any ideas how this could work?