related product logic

[hamza]

i have shopping cart i need to make the related product section in which i can show the related product when user view the product details.

 

do i need to create any table for it ?

 

please guide me about it.

thanks

[Maq]

I would imagine the best way to do this is to have a table for product categories.  Then in your products table assign each product categorie(s). 

[jdavidbakr]

There are a lot of ways you can go about it.  Like hamza said, you could show products in the same category.  You could build a table that links products with related products, and have a place in the admin where you can link products together (like if you have a DVD player as a product, you could link various cables that would be in a different  category but could be useful for the DVD player).  Whatever you do, you'll need to come up with how you will define the related products and that will probably get you started with what you'll need to do.