gvp16 Posted November 1, 2011 Share Posted November 1, 2011 Hi, all, I have a table that has a list of kits and their parts like so : KitCode, KitPrice, Part1, Part2, Part3, Part4, Part5, Part6, Part7, Part8, Part9, i then have a shopping basket with parts in: Part1 Part2 Part3 How can search to find it a kit has all the parts i have in my basket? Thanks. Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/ Share on other sites More sharing options...
fenway Posted November 1, 2011 Share Posted November 1, 2011 You normalize your database. Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/#findComment-1283894 Share on other sites More sharing options...
gvp16 Posted November 1, 2011 Author Share Posted November 1, 2011 can you please explain how that will help? each row already has its own identifier and there are no duplicates. Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/#findComment-1283913 Share on other sites More sharing options...
fenway Posted November 1, 2011 Share Posted November 1, 2011 You have part1...part9 -- those are duplicates. Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/#findComment-1283993 Share on other sites More sharing options...
gvp16 Posted November 1, 2011 Author Share Posted November 1, 2011 How? if part1 = 3641-001 part2 = 3646-001 part3 = 3647-001 how are they duplicated? Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/#findComment-1283994 Share on other sites More sharing options...
mikosiko Posted November 2, 2011 Share Posted November 2, 2011 this should help you to understand better... http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx scroll down and read about Normalization... specially about First Normal Form (1NF) and repeating groups Link to comment https://forums.phpfreaks.com/topic/250199-multifields-question/#findComment-1284125 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.