vegasman
12-05-2005, 09:12 AM
I have a highschool basketball site. I would like to display stat totals at the bottom of column. I've used the sum function but it only shows one column. How can I show all columns.
example of page is http://www.vpbasketball.net/profiles/riley_johnson.php
$query = "SELECT SUM(Points) AS Points FROM RileyJohnson";
$result = mysql_query($query);
<?php print(mysql_result($result, "Points")); ?>
the above is what I show total for points column but would like to show total for rebounds and other totals on bottom row for each column. I created a table for each player and has all his info plus stats. Each game displays results on each row. I'm using phpmyadmin in mysql on server. All I want is each column for each game added and displayed on bottom. Please help. Thankyou. Kris
Within one table called RileyJohnson.
Please help. Thankyou. Kris
example of page is http://www.vpbasketball.net/profiles/riley_johnson.php
$query = "SELECT SUM(Points) AS Points FROM RileyJohnson";
$result = mysql_query($query);
<?php print(mysql_result($result, "Points")); ?>
the above is what I show total for points column but would like to show total for rebounds and other totals on bottom row for each column. I created a table for each player and has all his info plus stats. Each game displays results on each row. I'm using phpmyadmin in mysql on server. All I want is each column for each game added and displayed on bottom. Please help. Thankyou. Kris
Within one table called RileyJohnson.
Please help. Thankyou. Kris