Hello all, Little question:
Say, i have two tables, USERS and PRODUCTS, for arguments sake. Now, all the products in the PRODUCTS table are unique by some value, say barcode, so it doesn't allow duplicates of the same product in the table. Now, a user can have several products associated with him. What is the best way to do this? Eventually a user would be able to log in and get an overview of his selected products, and add/remove products to his personal list from all the products in the PRODUCT table. A table that holds user_id in one column, and product_id in the other, maybe? But that would grow to a very large redundant table like this: user product 1 3 1 6 2 3 2 4 2 5 Etc. Any idea's? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
