ด่วนมาก รบกวนหน่อยค่ะ ยังไม่ได้เลยต่ะพี่ๆๆ ทำไงดี

<?
$connection = oci_connect("user", "password");

$query = "SELECT id, name, lob_field FROM fruits";

$statement = oci_parse ($connection, $query);
oci_execute ($statement);

while ($row = oci_fetch_array ($statement, OCI_ASSOC)) {
    echo $row['ID']."<br>";
    echo $row['NAME']."<br>";
    echo $row['LOB_FIELD']."<br>";  //this will output "Object id #1"
}
?>

<?php
for($i=$Page_Start;$i<$Page_End;$i++){ 
    $room_floor = $Result[1];   //เปลี่นจาก row เป็น Result ดูนะครับ
    $room_id = $Result[0]; 
    $room_sit = $Result[4]; 
     
if ($room_sit ==1) {  
    $sh = "bgcolor=\"red\"";  
    } else {  
    $sh = "bgcolor=\"green\"";  
    }  
?>

<?php

include "connect_odbc.php";
//include "function.php";
//$objConnect = oci_connect("pairin","flat","room");
$strSQL = "SELECT * FROM room ";
#$strSQL = "SELECT * FROM room ORDER BY room_id ASC";
$stmt = oci_parse ($conn, $strSQL);
$Result = oci_execute ($stmt, OCI_DEFAULT);
$Num_Rows = oci_fetch_all($stmt, $Result);

$Per_Page = 2; // แสดงต่อหน้า

$Page = $_GET["Page"];
if(!$_GET["Page"])
{
$Page=1;
}

$Prev_Page = $Page-1;
$Next_Page = $Page+1;

$Page_Start = (($Per_Page*$Page)-$Per_Page);
if($Num_Rows<=$Per_Page)
{
$Num_Pages =1;
}
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$Page_End = $Per_Page * $Page;
IF ($Page_End > $Num_Rows)
{
$Page_End = $Num_Rows;
}

?>
                    <tr bgcolor="#CCCCCC">
                      <td width="60" class="style30">ชั้น</td>
                      <td width="100" class="style30">ห้อง</td>
                      <td width="80" class="style30">สถานะ</td>
                    </tr>
<?
while ($row = oci_fetch_array ($statement, OCI_ASSOC)) {
for($i=$Page_Start;$i<$Page_End;$i++){
    $room_floor = $row[1];
    $room_id = $row[0];
    $room_sit = $row[4];
    
if ($room_sit ==1) { 
    $sh = "bgcolor=\"red\""; 
    } else { 
    $sh = "bgcolor=\"green\""; 
    } 
?>
<tr bgcolor="#e0eff8">
<td><div align="center"><?=$room_floor?></div></td>
<td><?=$room_id?></td>
<td <?=$sh?>><?=$room_sit?></td>
</tr>
<?
}
}
?>
        
                 </table>
<br>
Total <?= $Num_Rows;?> Record : <?=$Num_Pages;?> Page :
<?
if($Prev_Page)
{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){
if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
}
oci_close($conn);

?>