Re: Begging for help!!!! Thank you!!!!

Please help me! Lots of thanks! Milkman.

From: "Milk Man" <milkmansql@hotmail.com> To: milkmansql@hotmail.com, mysql@lists.mysql.com Subject: Beging for help!!!! Thank you!!!! Date: Tue, 25 Jul 2000 17:57:00 EDT 25 Jul 2000 14:15:26 EDT

Dear all, Please tell the newbie here if I am on the right track. I can't move further if I am not sure if I am on the right track. Dear Mr. DuBois, I read your book. It is very clear. But I don't know if the following design is normal/good? Could you please just give it a glance? I show 2 tables, each has 3 fields and 3 records. I think I'm trying to design a many-to-many tables. Thank you!!!! Milkman.

From: "Milk Man" <milkmansql@hotmail.com> To: mysql@lists.mysql.com Subject: Table Designs??? Date: Mon, 24 Jul 2000 18:47:16 EDT Hi all, I want a table to hold product info. Another table to store product type. One type may have many products and one product may have many types. Here is a simple data: Product Table: -------------

prodID  typeString         Description

1       AMD, Intel
2       AMD
3       Intel

Type Table: ------------

index  typeName      prodID

1           AMD           1
2           AMD           2
3           Intel         1
4           Intel         3

My site has search by categories. I have SELECT * FROM type, product WHERE type.typeName = 'AMD' AND type.prodID = product.prodID I use the field typeString in the Product table so that when people search by keywords, I only search the typeString and Description fields in the Product table (not the Type Table) and pull out the results. Is that the right way to go? And typeName is indexed (ofcourse product.prodID and type.index are indexed). Thank you very much. Milkman. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- --------------------------------------------------------------------- Please check "http://www.mysql.com/php/manual.php" before posting. To request this thread, e-mail mysql-thread45254@lists.mysql.com To unsubscribe, send a message to: <mysql-unsubscribe-milkmansql=hotmail.com@lists.mysql.com> If you have a broken mail client that cannot send a message to the above address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- --------------------------------------------------------------------- Please check "http://www.mysql.com/php/manual.php" before posting. To request this thread, e-mail mysql-thread45416@lists.mysql.com To unsubscribe, send a message to: <mysql-unsubscribe-milkmansql=hotmail.com@lists.mysql.com> If you have a broken mail client that cannot send a message to the above address(Microsoft Outlook), you can use http://lists.mysql.com/php/unsubscribe.php

________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com