Help

[minimitt]

I have a database that has a set of people stored in it. Each players has a score a average and total games played columns. When outputing the data I can print out each players name and such, I need to update each player with new scored after each week and add it to the previous weeks totals. How can I get the input into each player all at once. In my efforts I am only able to update one person at a time cause my variables only keep the last record after printing all of them out. Is there a way I can pick out the [n] player out of the database?

[crislewis]

It's a little difficult to understand exactly what you want to do here.

However, let's try and give an answer, anyway.

First, keep it simple. Separate the update from the reporting process.

Updates could be handled in a number of ways. The first to come to mind is:

on-line form - you use a browser form to update individual or multiple records. To create the form use PHP to generate a multi line form with inputs for, say player id and score (this should be done in a loop with PHP creating form fields which are unique in each row.

The php script called on submission merely trundles through the fields updating the relevant records.

A second option (if you have lots and lots of records to update) is to 'upload' the data to the server in a file and have php run through the file updating the database with the new data.

Hope this helps.

If you want more you need to tell us more.

Cheers,

Cris