Is there any solution NOT involving COUNT() ?
Otherwise the Drupal Handbook (http://drupal.org/node/161974) has the most straightforward PHP snippet:
<?php $mytype = 'job'; // <<---------- set your content type here. $results = db_query("SELECT COUNT(DISTINCT(nid)) FROM {node} WHERE type='%s' AND status=1", $mytype); $count = db_num_rows($results); echo "There are currently $count jobs in our database."; ?>
Victor Kane http://awebfactory.com.ar http://projectflowandtracker.com
On Wed, Dec 22, 2010 at 11:16 AM, Denis Lafont-Trevisan < denis.lafont@gmail.com> wrote:
Hi,
Just for the archive, the answer was using Views GroupBy module.
Cheers,
Denis
On Wed, Dec 22, 2010 at 12:36 PM, Shai Gluskin shai@content2zero.com wrote:
On Dec 22, 2010, at 3:23 AM, Denis Lafont-Trevisan < denis.lafont@gmail.com> wrote:
Hi,
Sounds stupid but I can't manage to create a view that count the number
of node of a certain type each user created.
Any clue?
Cheers,
Denis
[ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]