Justtechjobs.com Find a programming school near you






Online Campus Both


php-db | 2002122

[PHP-DB] Re: approaching a relational database From: Stas Trefilov (stas_t <email protected>)
Date: 12/16/02

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