Re: [PHP-DB] approaching a relational database

2002-12-16 Thread olinux
what kind of stats are you storing - scores? what fields do you need to store - these are necessary to help you start with the top and work your way down - courses have name, location, holes, members etc. - holes have par, distance, blah - members have blah, blah You can add/remove fields

[PHP-DB] approaching a relational database

2002-12-15 Thread Doug Parker
I'm about to embark on a project where I have to enter many, many fields into a MySQL database, and I don't know how to approach the database structure. The data is statistics for a golf course. There are 18 holes, and each hole has a Red Tee Par, White Tee Par, and Blue Tee Par, which is 54