<?php include('header.php'); ?>
<?php
    $host = "localhost";
    $user = "root";
    $pass = "";

    mysql_connect ($host, $user, $pass);
    mysql_select_db ("lorenzo");

    // =========================================

    $sql_category = "SELECT * FROM cv_category ORDER BY category_order ASC";
    $result_category = mysql_query ($sql_category) or die (mysql_error());

    echo    '<div id="about_text">
        <div id="h3_title"><h3>Curriculum Vitae</h3><h4>2007-Present</h4></div>
    </div>';
    while ($row_category = mysql_fetch_assoc ($result_category))
    {
        echo '<ul class="ul_cv">';
        echo "<li class='li_headline'>$row_category[category_label]</li><br />";
            // sub category output
            $sql_subcategory = "SELECT * FROM cv_subcategories WHERE fk_category = $row_category[category_id]";
            $result_subcategory = mysql_query ($sql_subcategory) or die (mysql_error());

            while ($row_subcategory = mysql_fetch_assoc ($result_subcategory))
            {
            echo "<li class='dot'>$row_subcategory[label]</li><br />";
                // entries output
                $sql_entries = "SELECT * FROM cv_entries WHERE fk_subcategory = $row_subcategory[id]";
                $result_entries = mysql_query ($sql_entries) or die (mysql_error());

                while ($row_entries = mysql_fetch_assoc ($result_entries))
                {
                    echo "<li class='cv_text'>$row_entries[entry_body]</li><br />";
                }
        }
    echo '</ul>';
        }
    ?>
<?php include('footer.php'); ?>