The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Right but the only problem is it seems that that would do it but the SAME award has to show 3 DIFFERENT values ie:

Double kill award 1'st class = 2, 2'nd class = 4, 3'rd class = 15.

And has to match up with the players profile that earned it.

I'm "most likely" wrong but the way that is shown it looks like it displays the award with only one value to be displayed.

I just couldn't figure out how to get it to display the way I wanted it to & it's a LOT of info & I didn't want to take the chance I'd do something wrong. That's a LOT to go back & redo if I screw something up & since i'm a newbie to php & MySQL that's REALLY likely to happen.

The Wins table would only have 3 fields: player_id, award_id and date.

It may seem easier for you at this point to have one massive table, BUT, as time goes by your database will become massive with duplicated information and from the looks of it, about 50 empty fields.

It will take you a little longer to learn how to do it the most efficient way now. Trust me, you don't want to have to split up your database and rewrite all your scripts 6 months from now when people are depending on your data.

An excellent book for you is "MySQL" by Paul DuBois. One third of the book is devoted to database theory. It is written in simple language with a sample database you can download and use to try out the example. It will show you how to put together a multiple table database and extract the information you need.

Another good book, is "PHP ESSENTIALS" by Julie Meloni. You can probably learn the same thing, but it doesn't go into the theory.

Both books cover PHP integration with MySQL. DuBois' book also covers using Perl and C to access data. Just skip that section.

Meloni's book shows how to use all the databases: MySQL, mSQL, postgre, Oracle and a few others.

Once you understand the theory, you will understand what I am talking about.