Re: [PHP] novice: table design FOREIGN key

2005-05-19 Thread Michael Satterwhite
tony yau wrote: | Hi All | | Thanks for all your comments on my previous mail, very much appreciated. | I'm stuck again! | I've created the following lookup table for m <-> m relationship between | a Group and a Contact table. | | CREATE TABLE Group_Contact( | GroupID INT NOT NULL, | Co

Re: [PHP] novice: table design FOREIGN key

2005-05-19 Thread John Nichel
tony yau wrote: Hi All Even though some people on this list were nice enough to answer your first OT question, this is still not a MySQL list. http://lists.mysql.com/ -- John C. Nichel ÜberGeek KegWorks.com 716.856.9675 [EMAIL PROTECTED] -- PHP General Mailing List (http://www.php.net/) To unsub

[PHP] novice: table design FOREIGN key

2005-05-19 Thread tony yau
Hi All Thanks for all your comments on my previous mail, very much appreciated. I'm stuck again! I've created the following lookup table for m <-> m relationship between a Group and a Contact table. CREATE TABLE Group_Contact( GroupID INT NOT NULL, ContactID INT NOT NULL, Index (Gr