[Answered] Query from one category to another

igcorreia
Topic Author
Offline
Platinum Member

11 years 11 months ago #24862 by igcorreia

[Answered] Query from one category to another was created by igcorreia

I need help please,

I have creating a custom category and template called:
Courses
From another template for and category called:
Videos
I want to COUNT how many item are inside the COURSES category.

My problem is that when I am in the VIDEOS category and I count $items the result is showing me all the items inside the VIDEOS category, what I need is something like this:

Code:

count($flexicontent->category['courser']->items);

Is something like this possible? Any help is welcome.

Please Log in or Create an account to join the conversation.

igcorreia
Topic Author
Offline
Platinum Member

11 years 11 months ago #24881 by igcorreia

Replied by igcorreia on topic [Answered] Query from one category to another

Any help? Please.

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

11 years 11 months ago #24886 by ggppdk

Replied by ggppdk on topic [Answered] Query from one category to another

If it is a subcategory of current category then info is already there , look at category_category.php

Otherwise you can use:

Code:

$catid = (int) $some_cat_slug;  // ...!!!

$query= 'SELECT COUNT(*) FROM #__content AS i'
. ' JOIN #__flexicontent_cats_item_relations AS rel ON rel.itemid = i.id'
. ' WHERE rel.catid='.$catid;

$db=JFactory::getDBO();
$db->setQuery($query);
$count = $db->loadResult();

echo $count;

Regards

-- Flexicontent is Free but involves a big effort on our part.
Like the our support? (for a bug-free FC, despite having a long list of functions) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing with a 5-star...

Please Log in or Create an account to join the conversation.

igcorreia
Topic Author
Offline
Platinum Member

11 years 11 months ago #24907 by igcorreia

Replied by igcorreia on topic [Answered] Query from one category to another

Your code incorrect i think.
Change:

Code:

$catid = (int) $some_cat_slug;  // ...!!!

To with example:

Code:

$catid = (98)   //Your Category ID!

The result is working correctly, I think.

Mark as Solved please.

Please Log in or Create an account to join the conversation.

micker
Offline
Administrator

11 years 11 months ago #24908 by micker

Replied by micker on topic [Answered] Query from one category to another

it's do !

FLEXIcontent is Free but involves a very big effort on our part.
Like the our support? (for a bug-free FC, despite being huge extension) Like the features? Like the ongoing development and future commitment to FLEXIcontent?
-- Add your voice to the FLEXIcontent JED listing reviews. Thanks![/size]

Please Log in or Create an account to join the conversation.

ggppdk
Offline
Administrator

11 years 11 months ago #24917 by ggppdk

Replied by ggppdk on topic [Answered] Query from one category to another

The line was an EXAMPLE, of course the variable "some_cat_slug" does not exist, it simply stated that the $catid must be a number. You might have the catid in the form :

"98:somecatname"

in this case you need to convert it to integer

Regards

Please Log in or Create an account to join the conversation.