[Shaneisace]

the concept should be the same for server side as the below

is this PHP or in-game?

PHP Version:
This is what you need (I use mysqli):

Code:

$count = mysqli_query($conn, "SELECT SUM(Items) FROM `table` WHERE `Items` > 0);
$sum = mysqli_fetch_array($count);

echo $sum['SUM(Items)'];

What mysql version are you using for your server?