Thread

Im trying to get a total count of entries, that all have the same Status as Processing.

But when i use the {total_results} variable, it repeats the number 3 times, if i have 3 entries with Status of Processing?

Here’s my code:

<div class="success">
You have {exp:channel:entries channel="{channels}" status="Processing"}{total_results}{/exp:channel:entries} new order(s)
</div>

I thought {total_results} just displayed once in a loop?

This is really inefficient query wise, but you could use what you have and just add

{if count == 1}{total_results}{/if}

You could also write your own query with the query module which would be far more optimized - or use something like this: http://devot-ee.com/add-ons/entries-number (albeit overpriced).

They query would look something like this:

{exp:query sql="
 SELECT 
  COUNT(entry_id) AS total_entry_count
 FROM
  exp_channel_titles
 WHERE
  channel_id = 1 AND status = 'open'
"} 

 {total_entry_count}
 
{/exp:query}

Magic, thanks. Yeah i was going to write a Query, but just wondered if there was a way with the channel entries.

Hey Shape.,

Looks like you are all set here? Is there anything else we can assist you with?

Cheers!

Excellent just what I needed right now, too. 😊 Thanks Philip!

Glad Philip was able to help everyone out here.

If anyone has any more questions, feel free to start a new thread.

Thanks!