Thread

I am having trouble with listing comments for a related entry (different from my last comment issue).

I have various (product) models and they are all categorized / linked to the same product under which they fall. ie. Product = Sony PS3. Models = PS3 120GB, PS3 160GB etc. On the frontend, people can comment under each model, but in the backend, the comments get associated with the product rather than each individual model.

So what I do is this below:

{related_entries id="db_model_product"}

<!-- comments section -->
{embed="templates/comments" 
entryid="{entry_id}"  <!-- entry_id of product (ie. PS3) -->
total_comments="?????"
weblog="db_product"
}

{/related_entries}

And with that template I can list all the comments that fall under a certain product.

Problem is I cant figure out how to conditionally display the comments. I only want to display comment info if {comment_total} > 0, but I don’t have access to that info outside of the template.

What would be a good way to access this variable?

You’d need to use the query module to bring back comment_total from exp_weblog_titles by passing in {entry_id} and use that result to do the rest of your embed.

Does that help?

Hi Sue,

Thanks for that, it works! The only thing I had to do was rename comment_total to get any result.

{exp:query sql="SELECT comment_total as comments FROM exp_weblog_titles WHERE entry_id = '{entry_id}' "}

<!-- comments section -->
{embed="templates/comments" 
entryid="{entry_id}"
comment_total="{comments}"
weblog="db_product"
}

{/exp:query}

Glad that worked. 😊 Don’t hesitate to post again as needed.