Re: [PHP] multiple categories

2009-03-02 Thread PJ
Paul M Foster wrote: > On Mon, Mar 02, 2009 at 11:50:15AM -0500, PJ wrote: > > >> I have a list of some 60 categories for a book database and am wondering >> what would be the best approach for inserting and selecting the data. >> My choices are to >> (1.)simply use one field in a books table an

Re: [PHP] multiple categories

2009-03-02 Thread Paul M Foster
On Mon, Mar 02, 2009 at 11:50:15AM -0500, PJ wrote: > I have a list of some 60 categories for a book database and am wondering > what would be the best approach for inserting and selecting the data. > My choices are to > (1.)simply use one field in a books table and enter the categories for > each

Re: [PHP] multiple categories

2009-03-02 Thread PJ
Andrew Ballard wrote: > On Mon, Mar 2, 2009 at 11:50 AM, PJ wrote: > >> I have a list of some 60 categories for a book database and am wondering >> what would be the best approach for inserting and selecting the data. >> My choices are to >> (1.)simply use one field in a books table and enter t

Re: [PHP] multiple categories

2009-03-02 Thread Andrew Ballard
On Mon, Mar 2, 2009 at 11:50 AM, PJ wrote: > I have a list of some 60 categories for a book database and am wondering > what would be the best approach for inserting and selecting the data. > My choices are to > (1.)simply use one field in a books table and enter the categories for > each book sep

[PHP] multiple categories

2009-03-02 Thread PJ
I have a list of some 60 categories for a book database and am wondering what would be the best approach for inserting and selecting the data. My choices are to (1.)simply use one field in a books table and enter the categories for each book separated by a comma (or whatever) as a text field and th