Number of links from a particular link category

colak · 2011-01-30 16:53:14

Is there a way to show in the front end, the number of links from a particular link category?

Something like the functionality of mdn_count but for link categories.

jsoo · 2011-01-30 17:16:48

It’s a simple query:

SELECT COUNT(*) FROM txp_link WHERE category = 'the_category'

which you can run via:

safe_count('txp_link', "category = 'the_category'");

(better because then safe_prefix() is built in)

or via smd_query (likewise).

I wouldn’t necessarily want to take this approach for a long category list, however — too many queries.

colak · 2011-01-30 17:29:00

Hi Jeff thanks for the quick reply but it doesn’t seem to work. It is 100% my fault though… I’m sure

This is what I have inserted in the page

<txp:php>safe_count('txp_link', "category = 'contributors'");</txp:php>

I wouldn’t necessarily want to take this approach for a long category list, however – too many queries.

What would a long list be? I currently have just under 400 links. Would that be too many queries?

jsoo · 2011-01-30 18:28:13

Try:

<txp:php>echo safe_count('txp_link', "category = 'contributors'");</txp:php>

colak wrote:

What would a long list be? I currently have just under 400 links. Would that be too many queries?

It’s the number of categories you want to display on the page that matters.

colak · 2011-01-31 06:09:38

jsoo wrote:

Try:

<txp:php>echo safe_count('txp_link', "category = 'contributors'");</txp:php>

oops. missed the echo. Thanks… this works:)

Textpattern CMS