Justtechjobs.com Find a programming school near you






Online Campus Both


php-windows | 2001042

Re: [PHP-WIN] Help on MYSQL Table design From: Toby Miller (tmiller <email protected>)
Date: 04/30/01

John,

No, you could just add another link table. So you would have the following
tables:

personal_info
------------------------------
ID -> unique id for family member
NAME -> family members name

family_info
------------------------------
ID -> unique id for family
F_NAME -> family name

personal_family_link
------------------------------
P_ID -> comes from personal_info.ID
F_ID -> comes from family_info.ID
RELATIONSHIP -> family members relationship

All of these fields would be required (NOT NULL).

Toby

----- Original Message -----
From: "John" <frizzy1994 <email protected>>
To: <php-windows <email protected>>
Sent: Sunday, April 29, 2001 8:57 AM
Subject: [PHP-WIN] Help on MYSQL Table design

> Hi Everybody,
>
> I have 2 tables: personal_info and family_info.
> For example, in personal_info, I have ID and NAME as fields. In
> family_info, I have ID, F_NAME and RELATIONSHIP as fields.
>
> The problem is in family_info, for each ID, I have several records. Do I
> need to have another field, say, COUNT in family_info so that I
> associate these records to each ID?
>
>
> Thanks.
>
> --
> PHP Windows Mailing List (http://www.php.net/)
> To unsubscribe, e-mail: php-windows-unsubscribe <email protected>
> For additional commands, e-mail: php-windows-help <email protected>
> To contact the list administrators, e-mail: php-list-admin <email protected>
> 

-- 
PHP Windows Mailing List (http://www.php.net/)
To unsubscribe, e-mail: php-windows-unsubscribe <email protected>
For additional commands, e-mail: php-windows-help <email protected>
To contact the list administrators, e-mail: php-list-admin <email protected>