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

Reply via email to