Re: [PHP-DB] novice on table design

2005-05-17 Thread thisisroot
people and another one for the n addresses of your >>>>people. >>>> >>>>If you keep your current schema, you will have as many rows for one >>>>person >>>>as many addresses for that person you have, and you will be >>>>duplica

Re: [PHP-DB] novice on table design

2005-05-16 Thread Jeremiah Fisher
ople and another for your people's addresses. -----Original Message----- From: tony yau [mailto:[EMAIL PROTECTED] Sent: Viernes, 13 de Mayo de 2005 09:27 a.m. To: php-db@lists.php.net Subject: [PHP-DB] novice on table design Hi all, I have the following tables EmployeeCustomer

Re: [PHP-DB] novice on table design

2005-05-14 Thread tony yau
>> people. > >> > >> If you keep your current schema, you will have as many rows for one > >> person > >> as many addresses for that person you have, and you will be > >> duplicating > > many > >> fields. So you must split you

Re: [PHP-DB] novice on table design

2005-05-13 Thread Tony S. Wu
hat person you have, and you will be duplicating many fields. So you must split your tables, one for your people and another for your people's addresses. -Original Message- From: tony yau [mailto:[EMAIL PROTECTED] Sent: Viernes, 13 de Mayo de 2005 09:27 a.m. To: php-db@lists.php.net Sub

Re: [PHP-DB] novice on table design

2005-05-13 Thread tony yau
;s addresses. > > -Original Message- > From: tony yau [mailto:[EMAIL PROTECTED] > Sent: Viernes, 13 de Mayo de 2005 09:27 a.m. > To: php-db@lists.php.net > Subject: [PHP-DB] novice on table design > > > > Hi all, > >

RE: [PHP-DB] novice on table design

2005-05-13 Thread Miguel Guirao
p.net Subject: [PHP-DB] novice on table design Hi all, I have the following tables EmployeeCustomernon-CustomerAddress ======= pkey pkeypkey pkey n

[PHP-DB] novice on table design

2005-05-13 Thread tony yau
Hi all, I have the following tables EmployeeCustomernon-CustomerAddress ======= pkey pkeypkey pkey number type type ...