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

Thank you Doug. I appreciate it. Can you take a look at my next question on the php list? It's the same topic but with query optimization. Thank you! Milkman.

From: Doug Semig <dougslist@c3net.net> To: milkmansql@hotmail.com, php-db@lists.php.net Subject: Re: [PHP-DB] Re: Begging for help!!!! Thank you!!!! Date: Tue, 25 Jul 2000 18:52:06 -0400 **Sent to the list and privately** A many-to-many relationship is typically modelled in three tables. Not one table. Not two tables. Three tables. In your case, it looks like they'd be called something like: product, type, and product_type. product (id, name, ...) type (id, name, ...) product_type (productid, typeid) The SQL to get your list would be something like: SELECT product.name, type.name FROM product, type, product_type WHERE product.id = product_type.productid AND

       type.id = product_type.typeid

If you wanted a specific product, you'd slap on "AND product.name LIKE 'Super Product 2000'" at the end of the where clause. If you wanted all products for a specific type, you'd slap on "AND type.name LIKE 'Intel'" at the end of the where clause. Play around with this model for a bit. I think you'll get the hang of it pretty quickly. HTH, Doug Milk Man was heard at 06:14 PM 7/25/00 EDT to say: 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