SELECT COUNT for column in database?

[harish3693]

How to Count number of rows in a table that matches to the related condition and echo that count out.

Code goes as follows::

    <?php 
         $sql = "SELECT * FROM input ORDER BY date DESC";
		 $result = $conn->query($sql);
								
		 if ($result->num_rows > 0) { 
         while($row = $result->fetch_assoc()) { 
         $myid = $row["id"] ;
     $sql3 = "SELECT COUNT question_id FROM output WHERE question_id = $myid";
		$result3 = $conn->query($sql3);
    ?>

    <div id="q">
            
			<small><p><?php echo $row["date"]; ?></p></small>
			<p id="tag3"><small><?php echo $result3['']; ?></small></p>
    </div>

Any Suggestions will be appreciated..

[RonB]

You need to use a GROUP BY clause.

"SELECT question_id, COUNT(*) FROM output GROUP BY question_id"