Hello All,

I have two tables.

Products and Articles.

From the Products Table, I have the ProductName i want to focus on.

From The Articles Table, i have a tag cloud that the user can input tags as comma separated values.

What i'm trying to do is display a list of related products for a given article Tag Cloud.

In Psuedo code, what i want to do is

Get All related products where the ProductName matches any of the Article Tag Clouds.

Example table data:

two products:
product 1: Products.ProductName: The Best Vitamin C In The World!
product 2: Products.ProductName: Multi-Vitamins for the average joe
Aritcles.Tags = Vitamins, Vitamin A, Vitamin C, Multi-Vitamins

SO i need to query the system and get all products when viewing a given article.

THank you in advance for the help!
Reply With Quote