several pointers to records in one field
| From: | Alain Barthélemy | Date: | Mon, 17 Mar 2003 17:36:46 +0000 |
| Subject: | several pointers to records in one field | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-26421@lists.php.net to get a copy of this message | ||
Hello,
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 row
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
cassandre@bartydeux.be
http://bartydeux.be