Welcome to WebmasterWorld Guest from 220.127.116.11
Looking at creating a related_products table but unsure the best way to create a relationship between this and the products/products to cat tables.
rel_id - prod_id_main - prod_id_also
If one the page where prod_id_main is showing pull results for any that match prod_id_also
Am I making this over difficult?
Hope someone can help
If thats not quite what you are after then when not created a related cell in your products database table, then add the related products ID's into this cell using a comma or some other delimiter to seperate each product relative to the one in question.
[edited by: PSWorx at 7:07 pm (utc) on Aug. 18, 2006]