Use this SQL
Code:
$sql = "select sum(vol) where user like 'abu'";
Why ... ?? Whenever possible, put the data calculation at the db server. Great advantage especially when webserver & db server are two different machine. Second, when dealing with text or string, use LIKE rather than "=".