content count

Submitted by Delphium on 13 September, 2012 - 15:47

Article Type: 
Article
Teaser Icon: 
WSGF
User Delphium has the following posts:-
Articles - ??
Blogs - ??
DR's - ??
Monitors - ??

$count =
$countt = 602



The query needs to search by username and node type, then count the node types. Below are some other examples of node counting for each type across the entire site, id like results based on per person and per node type, unless its possible to count multiple node types in a single query where the output is an array of the node type and the count of how many the user has submitted.
Nodes:-
  • blog : 427
  • poll : 13
  • product : 35
  • panel : 0
  • article : 607
  • dr : 2468
  • feed : 0
  • feed_item : 0
  • monitor : 0
  • news : 438
  • node_gallery_gallery : 0
  • node_gallery_image : 1611
  • page : 0
  • simplenews : 39
  • story : 0
Total number of nodes:- 5638


Users:- 5487


Comments:-
  • : 1
  • dr : 18
Total number of comments:- 19
    stdClass Object ( [users_name] => Delphium [count_types] => article,blog,dr,monitor,news,node_gallery_gallery ) 
    mysqli_result Object
(
    [current_field] => 0
    [field_count] => 3
    [lengths] => 
    [num_rows] => 2
    [type] => 0
)
  • dr 7
  • news 3