Get sum of MySQL column in PHP

Question

I have a column in a table that I would like to add up and return the sum  I have a loop  but it s not working   while   row   mysql fetch assoc  result         sum     row  Value       echo  sum

User · Answer

sql    SELECT SUM Value  FROM Codes     result   mysql query  query    while  row   mysql fetch array  result         sum    row  SUM price         echo sum

User · Answer

You can completely handle it in the MySQL query  SELECT SUM column name  FROM table name   Using PDO  mysql query is deprecated   stmt    handler- gt prepare  SELECT SUM value  AS value sum FROM codes     stmt- gt execute      row    stmt- gt fetch PDO  FETCH ASSOC    sum    row  value sum     Or using mysqli   result   mysqli query  conn   SELECT SUM value  AS value sum FROM codes      row   mysqli fetch assoc  result     sum    row  value sum

User · Answer

row  Value   is probably a string   Try using intval  row  Value      Also  make sure you set  sum   0 before the loop   Or  better yet  add SUM Value  AS Val Sum to your SQL query

User · Answer

Try this    sql   mysql query  SELECT SUM Value  as total FROM Codes     row   mysql fetch array  sql    sum    row  total

User · Answer

query    SELECT   FROM tableName    query run   mysql query  query     qty  0  while   num   mysql fetch assoc   query run          qty     num  ColumnName      echo  qty

User · Answer

Let us use the following image as an example for the data in our MySQL Database   Now  as the question mentions  we need to find the sum of a particular column in a table  For example  let us add all the values of column  quot duration sec quot  for the date  09-10-2018  and only status  off  For this condition  the following would be the sql query and code   sql qry    quot SELECT SUM duration sec  AS count      FROM tbl npt      WHERE date  09-10-2018  AND status  off  quot     duration    connection- gt query  sql qry    record    duration- gt fetch array     total    record  count     echo  total

User · Answer

result mysql query  SELECT SUM column  AS total value FROM table name WHERE column  value      result mysql result  result 0 0

User · Answer

I have replace your Code and it works well   sum 0  while   row   mysql fetch assoc  result         value    row  Value          sum     value     echo  sum

User · Answer

Get Sum Of particular row value using PHP MYSQL   SELECT SUM filed name  from table name

User · Answer

MySQL 5 6  LAMP    column value is the column you want to add up  table name is the table   Method  1   qry    SELECT column value AS count         FROM table name      res    db- gt query  qry     total   0  while   rec    db- gt fetchAssoc  res          total     rec  count      echo  Total       total     n     Method  2   qry    SELECT SUM column value  AS count          FROM table name      res    db- gt query  qry     total   0   rec    db- gt fetchAssoc  res    total    rec  count     echo  Total       total     n     Method  3 -SQLi   qry    SELECT SUM column value  AS count          FROM table name      res    conn- gt query  sql     total   0   rec   row    res- gt fetch assoc     total    rec  count     echo  Total       total     n     Method  4  Depreciated  don t use    res   mysql query  SELECT SUM column value  AS count FROM table name      row   mysql fetch assoc  res     sum    row  count

[php] Get sum of MySQL column in PHP

Examples related to php

Examples related to mysql