Hi, im currently developing a Webshop system. One of the new features of it should be a "Costumers that bought this product also bought...." feature - concerning this im currently unsure how to implement it - (LAMPS) - my current thought is following:
Costumer A buys Products with NO: 12, 13 , 25 -> system says OK, looks for Tables 12,13,25 -> finds nothing creates table 12, inserts 13 and 25 and sets sold of each to 1, then creates table 13 and 25 and inserts like it did in table 12 now cosumter B buys products 13,12,19 -> system says OK, looks for tables 13,12,19 and finds only 12 created, adds 19 into table 12 and updates sold from 13 in table 12 -> then does this with table 13 and finally creates table 19 (because new) and inserts like in Cosumter A's way... now the question: is MySQL aware of being with over 1500 tables ??? - is there a better way or more efficent way to do the same ? Hope sb. knows a trick :) Yours Sincerely Korbinian Bachl www.whiskyworld.de --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php