php - 对一列求和并保存为变量

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'];