How to get num of rows in php for a particular value [duplicate]

Question

In my database table, there are many students from different classes. I want to get the number of students in each class in a table. How can I get this and insert into a table? Here is my code:

        <?php

        function showSearchResult()
        {
            require_once('config.php');
            connect_db(); 
            $class = '';
            $result = mysql_query("SELECT * FROM ipsc_student WHERE class=2");
            $num_rows = mysql_num_rows($result);
            $rt = "";
            $rt.="<div align='center'>
                        <h1>Report IPSC</h1>
                </div>";
            $rt.= "<table width='1000' align='center' border= '1'>";
            $rt.= "<tr><td><b>SL</b></td>
                    <td><b>Class</b></td>
                    <td><b>Total Student</b></td>
                    </tr>";
            for($i =1; $i < 13; $i++){
                $rt.="<tr>";
                $rt.="<td>$i.</td>";
                $rt.="<td>$i</td>";
                $rt.="<td>$num_rows</td>";
                $rt.="</tr>";
            } 
        echo $rt;
        }
        showSearchResult();
        ?>

select class, count(class) as 'total' from ipsc_student group by class ?? — Professor Abronsius
– Professor Abronsius, Commented Oct 27, 2016 at 6:33

Jazzzzzz · Accepted Answer · 2016-10-27 06:45:47Z

1

You can do group by class on your student table

SELECT `class`, COUNT(`student`) AS total_student FROM `ipsc_student` GROUP BY `class`

edited Oct 27, 2016 at 6:45

answered Oct 27, 2016 at 6:33

Jazzzzzz

1,63316 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

jas appmakers · Accepted Answer · 2016-10-27 12:22:57Z

0

insert into newtablename (columnname) select count(*) from      
oldtablename group by class

newtablename - the new table where u want to store the count columnname - column name in the new table oldtablename - thwe old table where want the count of students of each class

edited Oct 27, 2016 at 12:22

answered Oct 27, 2016 at 7:18

jas appmakers

12 bronze badges

Collectives™ on Stack Overflow

How to get num of rows in php for a particular value [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related