The standard relational way is a relationship table:
PRIMARY KEY ( FK_parentID, FK_childrenID )
----- Original Message -----
From: "Alain Barthélemy" <[EMAIL PROTECTED]>
To: "php-db" <[EMAIL PROTECTED]>
Sent: Monday, March 17, 2003 6:36 PM
Subject: [PHP-DB] several pointers to records in one field
> I started to use PHP with MySQL last december.
> Personal use: list of inhabitants of a town in the 15th century
> Problem is the following: one person has an arbitrary number of children.
> It is heavy to have fields child1,child2,child3,...,childn containing the
> number of each child especially if the number of children is variable.
> When I played with Commodore VIC20 I used to put pointers to records in a
> string in the form pointer1,pointer2,...,pointern in a string.
> I think of using explode and implode to put all the record numbers of the
> children in one varchar field.
> If someone have a better idea?
> Alain Barthélemy
> [EMAIL PROTECTED]
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php