อยากทราบการดึงข้อมูลจาก Database มาแสดงทีละ 8 ค่าได้ไหมครับ?

echo "<table><tr><td>Room</td><td></td><td></td></tr>"
sql = "select * from tableRoom"
query(sql)
while xxx
{
echo "<tr><td>";
echo $objResult["room"];
echo "</td></tr>";
}
echo "</table>";

echo "<table><tr>";
sql = "select * from tableRoom"
query(sql)
$FloorNO = '0';
while xxx
{

if ($FloorNO != substr($objResult["room"],0,1)){

if ($FloorNO != '0'){
echo "</table></td>"; //ปิดตารางก่อนหน้า
}
//สร้างหัวตารางใหม่
echo "<td><table><tr><td>Room</td><td></td><td></td></tr>";
}

echo "<tr><td>";
echo $objResult["room"];
echo "</td></tr>";

$FloorNO = substr($objResult["room"],0,1);
}
echo "</tr></table>";

            <table class="table" id="tableRoom">
                <tbody>
                <hr>
                <?php
                if ($mysql->query(" SELECT * FROM [tb_room] ORDER BY CONVERT([nameRoom] USING tis620) ASC") > 0) {
                    $no = 1;
                    $i = 0;
                    $col = 4;

                    while ($rs = $mysql->fetch()) {
                        //echo $i;
                        if ($i % $col === 0) {
                            echo "<tr>";
                        }
                        ?>

                        <td><div  class="col-md-12">
                                <input  type="radio" id="room<?php echo $no; ?>" name="room" value="<?php echo $rs['idRoom']; ?>"> <?php echo $rs['nameRoom']; ?>
                            </div>
                        </td>
                        <?php
                        ++$no;
                        //++$i;
                        if (($i + 1) % $col === 0) {
                            echo "</tr>";
                        }

       ++$i;
                    }
                }
                //echo $i;
                if ($i > $col) {
                    for ($j = $i; $j % $col != 0; ++$j) {
                        ?>
                        <td><div  class="col-md-12"> &nbsp; </div></td>

                        <?php
                    }
                }

                if ($i % $col != 0) {
                    echo "</tr>";
                }
                ?>


                </tbody>
            </table>