$query = "SELECT SUM(`Price`) FROM `transaction` "; $result = mysql_query($query) or die(mysql_error()); while($row = mysql_fetch_array($result)) echo $row -> Price;