I have the following dashboard.php file, which i would like to display in table format

`<?php 

include '/config/connector.php';
// SQL query to display row count 
// in building table 
$sql = "SELECT * from bike_in where model = 'AE6+'"; 
if ($result = mysqli_query($conn, $sql)) { 
// Return the number of rows in result set 
$rowcount = mysqli_num_rows( $result ); 


// Display result
echo "<br />";
echo "<div style ='font:30px/21px Arial,tahoma,sans-serif;color:#ff0000'>"; 
printf("Total AE6+ sold are : %dn", $rowcount);
    echo "<br />";
    echo "<br /> </div>";

} 

$sql = "SELECT * from bike_in where model = 'AE6+' AND lot = '8'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
echo "<div style ='font:21px/21px Arial,tahoma,sans-serif;color:#000000'>"; 
printf("Lot 8 sold are : %dn", $rowcount); 
    echo "<br />";
} 

$sql = "SELECT * from bike_in where model = 'AE6+' AND lot = '53'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
printf("Lot 53 sold are : %dn", $rowcount); 
echo "<br />";
} 

$sql = "SELECT * from bike_in where model = 'AE6+' AND lot = '105'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
printf("Lot 105 sold are : %dn", $rowcount); 
echo "<br />";
    echo "<br />";
} 

// SQL query to display row count 
// in building table 
$sql = "SELECT * from bike_in where model = 'AE8+'"; 
if ($result = mysqli_query($conn, $sql)) { 
// Return the number of rows in result set 
$rowcount = mysqli_num_rows( $result ); 

// Display result 
echo "<br />";
echo "<div style ='font:30px/21px Arial,tahoma,sans-serif;color:#ff0000'>"; 
printf("Total AE8+ sold are : %dn", $rowcount);
echo "<br />";
    echo "<br /> </div>";
}

$sql = "SELECT * from bike_in where model = 'AE8+' AND lot = '8'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
printf("Lot 8 sold are : %dn", $rowcount); 
echo "<br />";
} 

$sql = "SELECT * from bike_in where model = 'AE8+' AND lot = '53'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
printf("Lot 53 sold are : %dn", $rowcount); 
echo "<br />"; 
} 

$sql = "SELECT * from bike_in where model = 'AE8+' AND lot = '105'"; 
if ($result = mysqli_query($conn, $sql)) { 
$rowcount = mysqli_num_rows( $result ); 
printf("Lot 105 sold are : %dn", $rowcount); 
echo "<br />";
} 

// Close the connection 
mysqli_close($conn); 

?>`

============================================================================

I’m attaching the images of what it is now and how i would like it to be!the expected table (i used excel to show)(https://i.sstatic.net/FY7ijFVo.png)the current text based(https://i.sstatic.net/Lhins9gd.png)](https://i.sstatic.net/Lhins9gd.png)

Advanced thanks Gurus.