Is it possible to fetch data from a database and then add that up

I know how to fetch from a database but is it possible to add all that data up for example get all data from "example" and then total that data, so i get a figure.
if so how do i do the addition part

 

With MYSQL you'd focus on this query.

SELECT COUNT(*) AS `num` FROM `table` WHERE `user` LIKE('%John%')

 

you use count to count the numbers of rows affected by the query but if you want to sum the numeric values inside the cells, you can use SUM()

use this as your reference
http://www.tizag.com/mysqlTutorial/mysqlsum.php

 

thanks alot for your help