Let's say I wanna count all entered data which is in one specific column.
I tried this code from another forums, but it gives me only total rows number:
$result = mysql_query("SELECT * FROM $table");
while($row = mysql_fetch_array($result)) {
$Total = Total + $row['Points'];
}
echo $Total;
I wanted something like this:
----------------------------'
USERS | POINTS |
----------------------------
John | 72 |
----------------------------
Smith | 68 |
----------------------------
James | 52 |
----------------------------
Linda | 87 |
==============='
Total points: | 279 |
---------------------------
Thanks so much, I appreciate!