content count

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

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

$count =
$countt = 596



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 : 32
  • panel : 0
  • article : 601
  • dr : 2369
  • 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:- 5530


Users:- 1280


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 8
  • news 3