php - 试图在 php 中显示 mysql 的总计

Question

我正在尝试使用 are int 获取 qunt 并将它们全部加起来并显示总数

$qunt = 0;
$result = mysql_query("SELECT * 
                         FROM properties_items 
                        WHERE user_propid='$view' 
                     ORDER BY id DESC") or die (mysql_error()); 

while ($row = mysql_fetch_array($result)) { 
  $itemid = $row['itemid'];
  $qunt = $row['qunt'];

  $qunt++;
}

echo $qunt;

Answer 1

$qunt = 0; 
$result = mysql_query("SELECT *  
                         FROM properties_items  
                        WHERE user_propid='$view'  
                     ORDER BY id DESC") or die (mysql_error());  

while ($row = mysql_fetch_array($result)) {  
  $itemid = $row['itemid']; 
  $qunt += $row['qunt'];  
} 

echo $qunt;

我敢说您可能没有使用 itemid，在这种情况下，在代码中循环结果集是没有意义的。相反，尝试这样的事情:

$qunt = mysql_query "SELECT SUM(qunt) FROM properties_items WHERE user_propid='$view'";