coding report

<table border="1" width="100%">
        <tr>
               <th>NRP</th>
                <?php
                        $query = "SELECT  day(tanggal) as hari FROM qtkerja WHERE month(tanggal)='11'";
                        $result = $mysqli->query($query);
                        while ($row = $result->fetch_array()){
                         echo '<th>'.strtoupper($row[0]).'</th>';
                        }
                ?>
        <?php
                $query1 = "SELECT nrp,tanggal as tgl_bd FROM qtmisdriver ";
                $result1 =$mysqli->query($query1);
                $tmp = ""; $i=1;
                while ($row = $result1->fetch_array()){
                        if ($row['nrp'] <> $tmp){
                                echo "</tr><tr><td>$row[nrp]</td>";
                                $tmp=$row['tgl_bd'];
                                $i++;
                        }else{
                                echo "<td>$row[tgl_bd]</td>";
                        }
                }
        ?>
</table>