Blog Documentation Book a Demo

Displaying Total number of views and Discussions

Sampath_AmitashSampath_Amitash New
edited October 2011 in Vanilla 2.0 - 2.8
In my vanilla forum installation, I would like to show the grand total of all the discussions and views. How can I do that?
Tagged:

Best Answer

  • x00x00 MVP
    Answer ✓
    Probably something like

    $TotalCount = Gdn::SQL()->Select('SUM(CountViews) As Total')->From('Discussion')->Value('Total');

    Then you have to decide where you are going to want to put it.

Answers

  • x00x00 MVP
    Answer ✓
    Probably something like

    $TotalCount = Gdn::SQL()->Select('SUM(CountViews) As Total')->From('Discussion')->Value('Total');

    Then you have to decide where you are going to want to put it.
  • x00x00 MVP
    edited October 2011
    Though probably you are going to need a denormalised version, becuase if you have many records it is going to be a quite an overhead to look it up every time.
  • camocamo New
    how would you do that with total members?

    would the above example be < php echo xxxxxx ? > or just that line?

    whats denormalised?
Sign In or Register to comment.