data in a table with titles and information

[ericko10kip]

             <?php
        $host="localhost"; // Host name
        $username="root"; // Mysql username
        $password=""; // Mysql password
            $db_name="relaxinn"; // Database name

        $con=mysqli_connect("$host","$username","$password","$db_name");
        if (mysqli_connect_errno($con)) {
    echo "Failed to connect to MySQL: " . mysqli_connect_error();
}

//Get number of rows
$categories = array();
$sql="SELECT * FROM books ";
$result=mysqli_query($con, $sql);
while($row=mysqli_fetch_assoc($result))
{
    $categories[$row['language']][] = $row['code'];

}  
//Start table
echo "<table>";

    // any type of outout you like
        foreach($categories as $key => $category){
 echo "<tr class='altrow' align='left'>";
 echo  "<th>" .$key.'<br/>'. "</th>";
 echo "</tr>";
 foreach($category as $item){ 

    echo "<tr class='altrow' align='left'>";
    echo "<td>" .$item.'<br/>'. "</td>";

    echo "</tr>";
     }

    }?>

[diafol]

What's the question?