RE: [PHP-WIN] Church Database

2004-10-15 Thread Gryffyn, Trevor
I know there are a million schools of thought on design structure, so I'm not trying to argue here, but I'd like to make some comments. > A few comments on Trevor's DB structure recommendations regarding > primary keys. > > 1) Only make the auto-incrementing primary key IF you don't > already h

Re: [PHP-WIN] Church Database

2004-10-15 Thread Felipe Gasper
A few comments on Trevor's DB structure recommendations regarding primary keys. 1) Only make the auto-incrementing primary key IF you don't already have a unique identifier for each item in the table. Your church probably doesn't have existing unique IDs for each member (or maybe you do - memb

RE: [PHP-WIN] Church Database

2004-10-15 Thread Gryffyn, Trevor
> The church has about 2000 members. The groups can range in > membership from > as few as 5 to as many as 300. > > I'm a novice programmer and was looking into using MySQL and PHP to > implement the system. > > Am I on the right track? > Any thoughts or suggestions? > Me being a beginner am I g