Count no of comments of an article

[ibblives]

I have this query which pulls records from two tables and works correctly.
Is there a way to add a third table (comments) so as to count the number of comments for an article.? Comments table has a foreign key artid with jt_articles primary key id.

Thank you

$query  = "SELECT M.id,M.j_surname,A.j_user_id,A.id,A.jart_title, A.jart_description, A.jart_createddate FROM jt_articles A, jt_members M where M.id = A.j_user_id ORDER BY A.jart_createddate DESC LIMIT $offset, $recordsPerPage;";  # 1. Main query

$result = mysql_query($query) or die('Mysql Err. 1');

[Sops21]

You could do something like:
$currentarticle = the id of the article

$query = "SELECT * FROM comments WHERE jt_articles = '$currentarticle'"
$query = mysql_query($query) or die(mysq_error());
$numcomments = mysql_num_rows($result); 

$numcomments would be the number of comments that the article has.

[bradgrafelman]

Welcome to PHPBuilder, ibblives!

As for your issue, you should be able to simply add a second join onto the comments table and add "COUNT(C.*)" to your SELECT's column lists (assuming "C" is the alias given to the comments table in the query). Give it a shot and if you can't figure it out, post what you tried and we can give you suggestions as to how it could be done instead.