Stats calculation

[kingsbest]

I have a table of members (18) with games played, won, drawn, lost and would like to know if its possible to have the points and percentage update automatically, example-

ID        Member             Grade Played Won Drawn Lost Points %

1 Player name             142 13         1         10         2   6     46.15

 

My web-page is currently static and i go to http://math.about.com/library/weekly/aa061502a.htm  fill in the games played and points and it gives the percentage, i have very little knowledge of php and by some miracle have managed to create a database using wamp and have extracted the data onto local host web page, my code as follows please let me know if i have any errors-

<?php
require "connect.inc.php"; 


echo "<table width='700'>
<tr>
<th></th>
<th>Member</th>
<th>Grade</th>
<th>Played</th>
<th>Won</th>
<th>Drawn</th>
<th>Lost</th>
<th>Points</th>
<th>&#37;</th>
</tr>";

$result = mysql_query("SELECT * FROM members");

while ($row = mysql_fetch_array($result)) 
  {
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['member'] . "</td>";
  echo "<td>" . $row['grade'] . "</td>";
  echo "<td>" . $row['played'] . "</td>";
  echo "<td>" . $row['won'] . "</td>";
  echo "<td>" . $row['drawn'] . "</td>";
  echo "<td>" . $row['lost'] . "</td>";
  echo "<td>" . $row['points'] . "</td>";
  echo "<td>" . $row['percentage'] . "</td>";
  echo "</tr>";
  }
echo "</table>";


?> 

Please tell me how i can have the points and percentage update automatically and keep in mind im a novice with php.

Best wishes,

John

[Insecure]

How about this:

 

<?php
require "connect.inc.php"; 


echo "<table width='700'>
<tr>
<th></th>
<th>Member</th>
<th>Grade</th>
<th>Played</th>
<th>Won</th>
<th>Drawn</th>
<th>Lost</th>
<th>Points</th>
<th>&#38;#37;</th>
</tr>";

$result = mysql_query("SELECT * FROM members");

while ($row = mysql_fetch_array($result)) 
  {
  $percent = round($row['points']/$row['played']*100, 2);
  echo "<tr>";
  echo "<td>" . $row['id'] . "</td>";
  echo "<td>" . $row['member'] . "</td>";
  echo "<td>" . $row['grade'] . "</td>";
  echo "<td>" . $row['played'] . "</td>";
  echo "<td>" . $row['won'] . "</td>";
  echo "<td>" . $row['drawn'] . "</td>";
  echo "<td>" . $row['lost'] . "</td>";
  echo "<td>" . $row['points'] . "</td>";
  echo "<td>" . $percentage. "</td>";
  echo "</tr>";
  }
echo "</table>";


?> 

[kingsbest]

Thanks Insecure,

  I'm guessing i now leave points and percentage empty in my database, i then replaced my code with yours and got the following-

 

Notice: Undefined variable: percentage in C:\wamp\www\Website\player_stats_test.php on line 107

 

Notice: Undefined variable: percentage in C:\wamp\www\Website\player_stats_test.php on line 107

 

ID Member       Grade Played Won Drawn Lost  Points %

1 John Amison 142         13         1         10    2

2 Neal Davies 108        8         0         5         3

 

best wishes,

John.

 

 

[wildteen88]

$percentage should be $percent

[kingsbest]

Thanks to both wildteen88 and Insecure  Its simply amazing and works, the world of php is mind blowing!

 

Thank you!!!

John

[Insecure]

No problem, sorry I forgot what I called it apparently lol.  Thanks for the catch wildteen.