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
------- --- --- --- ----- ----- ----- ----- -----
what is Course name, location, etc?
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php