to begin, its probably easy to break it into 2-3 pages, say:
view (index.php)
edit (edit.php)
add (add.php -- to add new players, depending on your need)
view would just use the first query above to pull all data from a database (which, im'm guessing would be pre-populated with player stats already?)
(note: this is a very rough sketch, not a great method really, but much easier to understand this way)
<?
/** VIEW **/
// connect to mysql above, run that query, and fetch_assoc into
// say a "$players" array
?>
<table>
<?
foreach($players as $row)
{
echo "<tr>";
echo "<td>$row[name]</td>";
echo "<td>$row[class]</td>";
echo "<td>$row[spent]</td>";
echo "<td>$row[earned]</td>";
echo "<td>$row[total]</td>";
echo "<td><form action='edit.php' method='post'>";
echo "<input type='hidden' name='player_id' value='$row[id]' />";
echo "Add: <input type='text' name='add' value='0' />";
echo "Sub: <input type='text' name='sub' value='0' />";
echo "<input type='submit' value='Adjust' /></form></td>";
echo "</tr>";
}
?>
</table>
/** EDIT **/
<?
// check what values are coming in
print_r($_POST);
//
// run 2nd query from my last post
//
?>
further note: i doubt this will work 'as is' copy/pasted, but it should give an idea of a simple direction to head toward.
(or go nuts, grab the prototype javascript lib, ajaxify it and go back to gaming haha)
