Re: [PHP] How to deal with identical fields in db

2009-05-06 Thread Peter Ford
tedd wrote: > At 3:14 AM -0700 5/6/09, Michael A. Peters wrote: >> Peter Ford wrote: >>> >>> tedd wrote: (and I added in some extra bits...) You need to normalize. Authors should have an unique id in an authors table. The authors table has all the specific information about auth

Re: [PHP] How to deal with identical fields in db

2009-05-06 Thread tedd
At 3:14 AM -0700 5/6/09, Michael A. Peters wrote: Peter Ford wrote: tedd wrote: (and I added in some extra bits...) You need to normalize. Authors should have an unique id in an authors table. The authors table has all the specific information about authors, but not the books they have writte

Re: [PHP] How to deal with identical fields in db

2009-05-06 Thread Michael A. Peters
Peter Ford wrote: tedd wrote: (and I added in some extra bits...) You need to normalize. Authors should have an unique id in an authors table. The authors table has all the specific information about authors, but not the books they have written. Books should have an unique id in a books table

Re: [PHP] How to deal with identical fields in db

2009-05-06 Thread Peter Ford
tedd wrote: (and I added in some extra bits...) > You need to normalize. > > Authors should have an unique id in an authors table. The authors table > has all the specific information about authors, but not the books they > have written. > > Books should have an unique id in a books table. The

Re: [PHP] How to deal with identical fields in db

2009-05-05 Thread PJ
Tom Worster wrote: > On 5/5/09 4:42 PM, "Richard S. Crawford" wrote: > > >> On Tue, May 5, 2009 at 1:34 PM, PJ wrote: >> >>> I'm coming up with a bit of a quandry: how to enter and retrieve an >>> identical book title with different authors. >>> It is rather unbelievable what contortions

Re: [PHP] How to deal with identical fields in db

2009-05-05 Thread Tom Worster
On 5/5/09 4:42 PM, "Richard S. Crawford" wrote: > On Tue, May 5, 2009 at 1:34 PM, PJ wrote: >> I'm coming up with a bit of a quandry: how to enter and retrieve an >> identical book title with different authors. >> It is rather unbelievable what contortions one finds as authors :-( >> like editor

Re: [PHP] How to deal with identical fields in db

2009-05-05 Thread tedd
At 4:34 PM -0400 5/5/09, PJ wrote: I'm coming up with a bit of a quandry: how to enter and retrieve an identical book title with different authors. It is rather unbelievable what contortions one finds as authors :-( like editors, associations and then the unknowns and anon y mouses. I suppose one

Re: [PHP] How to deal with identical fields in db

2009-05-05 Thread Stephen
PJ wrote: I'm coming up with a bit of a quandry: how to enter and retrieve an identical book title with different authors. It is rather unbelievable what contortions one finds as authors :-( like editors, associations and then the unknowns and anon y mouses. I suppose one has to get really creati

Re: [PHP] How to deal with identical fields in db

2009-05-05 Thread Richard S. Crawford
On Tue, May 5, 2009 at 1:34 PM, PJ wrote: > I'm coming up with a bit of a quandry: how to enter and retrieve an > identical book title with different authors. > It is rather unbelievable what contortions one finds as authors :-( > like editors, associations and then the unknowns and anon y mouses.