I have created a table of article names as hotlinks to their url. I have Jcomments installed where people can comment on each article. I want to display and sort by the number of comments on any given article.

I am lost as to how to pull that value and display it, only able to create the base query as follows:

SELECT * FROM `hrq3k_content` WHERE `catid` = '8'

I want to had a sum total of the related comments in table=hrq3k_jcomments where hrq3k_content/id = hrq3k_jcomment/object_id. If you can help me with the query, I think I can figure out the rest.

Thanks,

This wil be like the 10th project I have used your stuff with and you have always been very helpful (Yes, I bought a fresh license for this new site).

Hello,

Could you provide an SQL dump of used tables or a temporary access to your J! backend by email so we can help to create the query.

Regards,
ARI Soft