Doug Parker wrote:
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 inputs already (18 x 3). Then, there are about 5 more statistics I have to keep for each hole, making the total amount of inputs 144 (18 x 8). There's about 7 more fields pertaining to the Course name, location, etc. How the heck do I approach this? I've successfully done relational databases before, but not to this scale. Does anyone have any suggestions as to how I should approach this?
I attached a .jpg of the form I'm using to input, just to clarify things.
Any suggestions would be greatly appreciated...
table could look like this:
hole_no, rtp, wtp, btp, stat1, stat2, stat3, stat4, stat5 ------- --- --- --- ----- ----- ----- ----- ----- 1 2 3 . . . 18 what is Course name, location, etc? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
