I have this query to pull results from two tables which displays articles and their users correctly but I want to add another table (Comments) which will get the number of comments on each article. Comments table has a foreign key artid which is linked to Articles table id.
Can someone help?
$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;";
$result = mysql_query($query) or die('Mysql Err. 1');