<div>
Select article.title, article.text, article.picture, (select count(*) from comment where articleid = article.id ) as commentcount FROM article;
</div>


<div>
<div class="content wysiwyg-content">
Hi all<br />
<br />
A quick (and hopefully easy) question.<br />
<br />
We have two tables, one for storing atricles, and another for storing comments assciated &nbsp;with the article.<br />
<br />
Table Article<br />
ID, picture, title, text<br />
<br />
Table comment<br />
ID, articleID, comment<br />
<br />
Now I want to be able to select the following;<br />
<br />
article.title, article.text, article.picture, Count(select row countof comments associated with article) FROM article;<br />
<br />

</div>
</div>


Hi all

A quick (and hopefully easy) question.

We have two tables, one for storing atricles, and another for storing comments assciated  with the article.

Table Article
ID, picture, title, text

Table comment
ID, articleID, comment

Now I want to be able to select the following;

article.title, article.text, article.picture, Count(select row countof comments associated with article) FROM article;



Select article.title, article.text, article.picture, (select count(*) from comment where articleid = article.id ) as commentcount FROM article;

select count and information from table mysql

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.