用于保存分数的PHP SQL数据库

Question

I've got a database setup for scores, each score is out of 100 and i need to be able to save more than one value and output it so that a user can see it. I have no idea however how to save the scores; my knowledge of php is limited and i only know how to save one value.

Thanks in advance

Answer 1

Based on your comments I think you could get by with something like this:

 mysql_query("INSERT INTO scores(name, score) VALUES ('John', 100),('John', 75),('Bob', 68)");

Or

 mysql_query("INSERT INTO scores(name, score) VALUES ('John', 100)");
 mysql_query("INSERT INTO scores(name, score) VALUES ('John', 75)");
 mysql_query("INSERT INTO scores(name, score) VALUES ('Bob', 68)");

If you wanted a specific users score you could do:

 mysql_query("SELECT score FROM scores WHERE name='John'");

If you wanted a list of users:

 mysql_query("SELECT name FROM scores GROUP BY name");