Need Help: count all data from one sql column

[maroqand]

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!

[Hybride]

SUM().

[fenway]

SELECT sum(points) from $table

[Ken2k7]

You can use your SELECT statement you have up there and then UNION it with the SQL fenway posted.