Empty table row when location id changes – Mysql

It should just be a case of looping through the data, and keeping track of what Location ID was used in the previous row, so you can compare it to the current one, and then decide whether to add an extra line or not.

P.S. There’s also a lot of repeated code in your original, so I took the liberty of removing the repetition – changing the logic around where you create new rows to just do that once, and also using variables to represent what changes in the different echo statements (which is only a class name, and the addition of an extra table row) so you only need to state most of the HTML once, and lastly refactoring it to get rid of all the escape characters which were cluttering it up too.

Oh an your HTML table was technically malformed because you didn’t put any <td> cells into the row.

For that reason, let’s take this in stages. This first version is equivalent to producing the output that you have now:

$colLimit = 5;
$colCount = 1;
$tableHTML = "<table border='0' width='100%' cellspacing='2'>".PHP_EOL;
                  
while ($row_ConfMon = mysqli_fetch_assoc($ConfMon))
{ 
    $locationid = $row_ConfMon['hotelID'];
    $RoomNo2 = $row_ConfMon['deviceName'];
    $companyname = $row_ConfMon['companyname'];
    $recordID = $row_ConfMon['record_ID'];
    $location = $row_ConfMon['location'];
    $DownDate = date("d-m-y", $row_ConfMon['uptime']);
    $DownTime = date("H:i", $row_ConfMon['uptime']);
    
    $rowHTML = "";
    $className = "";

    if ($colCount == 1)
    {
        $rowHTML .= "<tr>".PHP_EOL;
    }
    
    if($row_ConfMon['NoDevice'] == 1) $className = "roomviewpurple";
    elseif($row_ConfMon['MobileDisplay'] == 1 && $row_ConfMon['messageCount'] == 2) $className = "roomviewamber";
    elseif($row_ConfMon['messageCount'] == 2) $className = "roomviewred";
    else $className = "roomviewgreen";
    
    $linkHTML = '<td><a href="confmon.php" target="_self"><td class="'.$className.'" valign="top"><div class="coltitle"><a href="confmon_hist.php?recordID='.$recordID.'" target="_self">'.$companyname.'</a></div> <div class="confmontime2">'.$location.'<br />'.$RoomNo2.'<br /></div><span class="confmontime">'.$DownDate.'<br /><div class="confmontime2">'.$DownTime.'</div><br /></span></td></a></td>'.PHP_EOL;
    $rowHTML .= $linkHTML;

    if ($colCount == $colLimit)
    {
        $rowHTML .= "</tr>".PHP_EOL;
        $colCount = 1;
    }
    else $colCount++;
    
    $tableHTML .= $rowHTML;
}

//tidy up end of table
if (substr($tableHTML, -4) != "</tr>") $tableHTML .= "</tr>".PHP_EOL;
$tableHTML .= "</table>";

//output the table
echo $tableHTML;

Live demo: https://3v4l.org/HQqL3

Now this next one should do the job for starting a new row when the location field has changed. As you can see, I’ve added a variable to keep track of the location ID from the previous row, so we can compare it, and also changed the point where it decides whether to end the row and reset the column count – it’s delayed until we’re processing the start of the next row, so there’s the opportunity to compare the location IDs. As per your comment below, it also adds another row for spacing, when changing location ID:

$colLimit = 5;
$colCount = 1;
$tableHTML = "<table border='0' width='100%' cellspacing='2'>".PHP_EOL;
$prevLocationID = ""; //to keep track of the location on the preceding data item
                  
while ($row_ConfMon = mysqli_fetch_assoc($ConfMon))
{ 
    $locationid = $row_ConfMon['hotelID'];
    $RoomNo2 = $row_ConfMon['deviceName'];
    $companyname = $row_ConfMon['companyname'];
    $recordID = $row_ConfMon['record_ID'];
    $location = $row_ConfMon['location'];
    $DownDate = date("d-m-y", $row_ConfMon['uptime']);
    $DownTime = date("H:i", $row_ConfMon['uptime']);
    
    $rowHTML = "";
    $className = "";

    if ($colCount == $colLimit || $prevLocationID != $locationid)
    {
        $rowHTML .= "</tr>".PHP_EOL;
        if ($prevLocationID != $locationid) $rowHTML .= "<tr></tr>.PHP_EOL";
        $colCount = 1;
    }
    else $colCount++;

    if ($colCount == 1)
    {
        $rowHTML .= "<tr>".PHP_EOL;
    }
    
    if($row_ConfMon['NoDevice'] == 1) $className = "roomviewpurple";
    elseif($row_ConfMon['MobileDisplay'] == 1 && $row_ConfMon['messageCount'] == 2) $className = "roomviewamber";
    elseif($row_ConfMon['messageCount'] == 2) $className = "roomviewred";
    else $className = "roomviewgreen";
    
    $linkHTML = '<td><a href="confmon.php" target="_self"><td class="'.$className.'" valign="top"><div class="coltitle"><a href="confmon_hist.php?recordID='.$recordID.'" target="_self">'.$companyname.'</a></div> <div class="confmontime2">'.$location.'<br />'.$RoomNo2.'<br /></div><span class="confmontime">'.$DownDate.'<br /><div class="confmontime2">'.$DownTime.'</div><br /></span></td></a></td>'.PHP_EOL;
    $rowHTML .= $linkHTML;

    $prevLocationID = $locationid; //set "previous" location ID as the current one, ready for processing the next data item
    $tableHTML .= $rowHTML;

}

//tidy up end of table
if (substr($tableHTML, -4) != "</tr>") $tableHTML .= "</tr>".PHP_EOL;
$tableHTML .= "</table>";

//output the table
echo $tableHTML;

Live demo: https://3v4l.org/KRiU1