How to use Table Data in Table Headers , PHP5, Mysql

i am creating a daily report grouped by the types of product, at the moment this is displayed as a list as below

what i am trying to achieve is to use the eggtype as the headers with the required volume underneath. showing the daily total of all egg_type at the end

Here is the code i am currently using

<table id="datatable2" name="datese" class="table table-striped table-bordered" style="width:100%">
                        <thead>
        <tr>
    
        <td>Date</td>
        <td>Egg Type</td>
        <td>Product</td>
        <td>Total Kg</td>

        </tr> 
        </thead>
                     <?php

// Connect to database server
    mysql_connect("localhost", "cl30-bumble", "password") or die (mysql_error ());

    // Select database
    mysql_select_db("cl30-bumble") or die(mysql_error());

$post_at = $_POST["start_date"]; 
$post_at_to_date = $_POST["end_date"];

$query = "SELECT egg_type, egg_group, total_kg, production_date, SUM(total_kg) FROM order_process WHERE production_date BETWEEN '$post_at' AND '$post_at_to_date' AND product_cat = 'liquid_egg'  GROUP BY egg_type, egg_group, production_date ORDER BY FIElD(production_date,'Monday','Tuesday','Wednesday','Thursday','Friday') "; 
     
$result = mysql_query($query) or die(mysql_error());

// Print out result
while($row = mysql_fetch_array($result)){
    
 echo ' 
        <tr>
    
        <td>'.$row["production_date"].'</td>
        <td>'.$row["egg_type"].'</td>
        <td>'.$row["egg_group"].'</td>
        <td>'.$row["SUM(total_kg)"].'</td>
    
        
        
        </tr>
       
        ';
}
mysql_close();


?>
 </table>

i now this old version of php as im carrying on from last creator using php5.4 to develope this application .

Any help or guidance would be much appreciated. or if this is even possible.

Thank you

new to php mysql, so been reading through books and or course Google 🙂 cannot find how to do the above