Untitled

<html>

    <h1>Report showing flatpacks order by name within type </h1>
<body>
<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "courseworkv2";
$mysqli = new mysqli($servername, $username, $password, $database);
 if ($mysqli->connect_error) {
      die("Connection failed: " . $conn->connect_error);
  }
$query = "SELECT flatpack_apn.flatpackid,
       flatpack_apn.name,
       flatpack_apn.colour,
       flatpack_apn.type,
       flatpack_apn.unitprice,
       flatpackcomponent_apn.componentno,
       component_apn.description
FROM   flatpackcomponent_apn
       LEFT JOIN component_apn
              ON flatpackcomponent_apn.componentno = component_apn.componentno
       INNER JOIN flatpack_apn
               ON flatpackcomponent_apn.flatpackid = flatpack_apn.flatpackid
ORDER  BY flatpackid ASC  ";


echo '<table border="0" cellspacing="2" cellpadding="2">
      <tr>
          <td> <font face="Arial">FlatpackID</font> </td>
          <td> <font face="Arial">Name</font> </td>
          <td> <font face="Arial">Colour</font> </td>
          <td> <font face="Arial">Type</font> </td>
           <td> <font face="Arial">UnitPrice</font> </td>
            <td> <font face="Arial">ComponentNo</font> </td>
             <td> <font face="Arial">Description</font> </td>

      </tr>';


if ($result = $mysqli->query($query)) {
    while ($row = $result->fetch_assoc()) {
        $field1name = $row['FlatpackID'];


        echo '<tr>
                  <td>'.$field1name.'</td>


              </tr>';
    }
    $result->free();
}
?>
</body>
</html>