RE: [PHP-DB] Database Design Recommendations

2004-11-02 Thread Hutchins, Richard
Eric, There are, as you will find out, a number of ways you could handle it. The right way is really your decision and it's directly related to the flexibility, maintainability, and security your site will require. I have had success in the past using a role-based permission system. For example,

Re: [PHP-DB] Database Design Recommendations

2004-11-02 Thread Miles Thompson
Eric, Your second approach is fine. It's denormalized, extensible, and can be manipulated using tools you put in place. You may want to consider groups as well, thus people belonging to a group could view/edit pages, that has the potential to save a lot of administrative scut work. A table

Re: [PHP-DB] Database Design Recommendations

2004-11-02 Thread -{ Rene Brehmer }-
At 23:36 01-11-2004, Eric Cranley wrote: I tried to find this in the archives. If I missed it, my apologies in advance. I'm developing an intranet for my company, and we are planning on putting sensitive information on it. I've already setup a login system using sessions, but I'm not sure how to