对列的总和求和并另存为变量

Question

尝试对列的总和进行求和并另存为变量。正如我用PHPMyAdmin测试过的那样，这个查询已经正常工作了。只是在努力将查询得到的图形保存到一个变量中。

 $con = mysql_connect(DB_HOST, DB_USER, DB_PASS);
 if (!$con)
   {
   die('Could not connect: ' . mysql_error());
   }

 mysql_select_db(DB_NAME, $con);

 $result = mysql_query("SELECT SUM(column_name) FROM tablename");



  mysql_close($con);  

任何帮助都将不胜感激。

谢谢!

Answer 1

试试这个：

$result = mysql_query("SELECT SUM(column_name) as soma FROM tablename");

$row= mysql_fetch_array($result);

$sum= $row['soma'];

Answer 2

我相信这样的东西会起作用的：

$result = mysql_query("SELECT SUM(column_name) as thesum FROM tablename");
$sum = mysql_result( $result, 0, "thesum");

或者，这应该是可行的：

$sum = mysql_result( $result, 0);

Answer 3

$sql = "Select SUM(ver) AS ver from tablename";
$sum = mysql_query($sql);
$result= mysql_fetch_object($sum);
echo $result->ver;