homepage Welcome to WebmasterWorld Guest from 54.196.198.213
register, free tools, login, search, subscribe, help, library, announcements, recent posts, open posts,
Accredited PayPal World Seller

Visit PubCon.com
Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

    
Handling related products
related products php
frozenpeas




msg:3051701
 3:39 pm on Aug 18, 2006 (gmt 0)

Hi building a store in PHP and coming unstuck with the layout of the database and making a related products section.

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.

Thinking of:

related_products

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

 

PSWorx




msg:3051991
 7:06 pm on Aug 18, 2006 (gmt 0)

If you products are category base why not pull products which are in the same category as the one in questions.

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]

Global Options:
 top home search open messages active posts  
 

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About
© Webmaster World 1996-2014 all rights reserved