[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

Re: [PHP] multiple categories

2009-03-02 Thread Andrew Ballard
On Mon, Mar 2, 2009 at 11:50 AM, PJ af.gour...@videotron.ca 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

Re: [PHP] multiple categories

2009-03-02 Thread PJ
Andrew Ballard wrote: On Mon, Mar 2, 2009 at 11:50 AM, PJ af.gour...@videotron.ca 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

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
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 and enter