在PHP中计算SUM

Question

<?php

 $today=date('Y-m-d');
  $sorgu = mysqli_query($conn, "SELECT * FROM urun");
  while ($sira = mysqli_fetch_array($sorgu)) {
  $urun = $sira['urun'];

  $query = mysqli_query($conn, "SELECT product_name, birim, SUM(quantity) FROM 
  product WHERE product_name = '$urun' AND quantity != '0' AND quantity > '0' 
  AND grup!='uygulama' AND skt > '$today' GROUP BY product_name, birim ");

  while ($row = mysqli_fetch_array($query)){
  if ($row['2'] <= $sira['minstok']) {

  echo count($row['0']);

} } } ?>

This code belongs to a table which has a notification system. I want the notification part increase when the line number increases in that table but it turns 11111111... , So how can I make the code give me sum?

Answer 1

Incidentally, everything up to while ($row... can be rewritten as follows:

SELECT p.product_name
     , p.birim
     , SUM(p.quantity) total 
  FROM urun u
  JOIN product p
    ON p.product_name = u.urun
   AND p.quantity > 0
   AND p.grup != 'uygulama' 
   AND p.skt > CURDATE()
 GROUP 
    BY p.product_name
     , p.birim;