The following warnings occurred:
Warning [2] Undefined variable $unreadreports - Line: 26 - File: global.php(961) : eval()'d code PHP 8.2.25 (Linux)
File Line Function
/global.php(961) : eval()'d code 26 errorHandler->error
/global.php 961 eval
/showthread.php 28 require_once





× This forum is read only. As of July 23, 2019, the UserSpice forums have been closed. To receive support, please join our Discord by clicking here. Thank you!

  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Column Sum
#2
Count gives you the number of rows returned in your query. Use $db->first(); to return the first row which is all you will have given you are only selecting the sum. Also, after this, you will need to have the column you want to output.

I would:
-Change your select to be SUM(sendout) AS Total (or whatever you want to call it)
-Make your $count = to $db->first()->Total;

Then you can echo it Smile
  Reply


Messages In This Thread
Column Sum - by matt - 11-01-2017, 11:03 AM
Column Sum - by Brandin - 11-01-2017, 11:54 AM
Column Sum - by mudmin - 11-01-2017, 02:35 PM

Forum Jump:


Users browsing this thread: 2 Guest(s)