Guest yoruldum Posted November 28, 2003 Share Posted November 28, 2003 Hi there, I have a problem as you can imagine There is a table which has a list of products.For example we are buying product A from 3 suppliers and product B from 5 suppliers which of 2 suppliers are same. I want to have ability to search this table like \"SELECT * FROM products WHERE product_name = \'A\'\" and fetch suppliers name from that dataset. If I create one field called suppliers and add values like \"supp1,supp2,supp3\" than the result will be one string and I have to parse these one by one. Is there any easier way for that freaks Link to comment https://forums.phpfreaks.com/topic/1434-newbie-array-field/ Share on other sites More sharing options...
sirmanson Posted December 2, 2003 Share Posted December 2, 2003 You should probably create another table that just keeps track of which suppliers stock which products. Since you have a \"many-to-many\" relationship it should not be stored with your products. Link to comment https://forums.phpfreaks.com/topic/1434-newbie-array-field/#findComment-4785 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.