Untitled

<?php
//database login creditials
$host = "localhost";
$user = "root";
$pass= "stylish09";
$db = "portfoliosystem";

//connect to mysql server and select database
$sql = mysql_connect($host, $user, $pass) or die("(".mysql_errno.")".mysql_error());
mysql_select_db($db) or die("(".mysql_errno.")".mysql_error());
?>

<html>
    <head>
        <title>Portfolio System</title>
    </head>
    <body>
        <div id="container">
            <div id="header" align="center">
                <h1>Portfolio System</h1>
            </div>
            <div id="content">
                <table>
                    <tr>
                    <?php
                    $firstname;
                    $lastname;
                    $nickname;
                    if(($userquery = mysql_query("SELECT * FROM rh_user WHERE id='1'", $sql)))
                    {
                        $userrow = mysql_fetch_array($userquery);

                       $firstname = $userrow[1];
                       $lastname = $userrow[2];
                       $nickname = $userrow[4];
                    }
                    else
                    {
                        $userrow = "User not found";
                    }

                    ?>
                        <td style="padding-left: 100px; padding-top: 20px; padding-bottom: 50px;"><p><?php echo $firstname." ".$lastname." A.K.A. ".$nickname; ?></p></td>
                    </tr>

                    <!--foreach category-->
                    <?php
                    $categoriesrow;
                    if(($categoriesquery = mysql_query("SELECT * FROM rh_portfolio_categories", $sql)))
                    {

                        while(($categoriesrow = mysql_fetch_array($categoriesquery)))
                        {
                    ?>
                        <tr>
                            <td style="padding-left: 150px;"><h2><?php echo $categoriesrow["title"]." (<font size='3'><i>".$categoriesrow["description"]."</i></font>)"; ?></h2></td>
                        </tr>
                        <tr>
                            <td style="padding-left: 170px;">
                            <?php
                            $typesrow;
                            if(($typesquery = mysql_query("SELECT * FROM rh_portfolio_types WHERE catid=".$categoriesrow["id"], $sql)))
                            {

                                while(($typesrow = mysql_fetch_array($typesquery)))
                                {
                                    ?>
                                <table>
                                    <tr>
                                        <td><h5><?php echo $typesrow["type"]; ?></h5></td>
                                        <?php
                                        $entriesrow;
                                        if(($entriesquery = mysql_query("SELECT * FROM rh_portfolio_entries WHERE typeid=".$typesrow["id"]." && userid=1 && categoryid=".$categoriesrow["id"], $sql)))
                                        {

                                            while(($entriesrow = mysql_fetch_array($entriesquery)))
                                            {
                                                $entry = wordwrap($entriesrow["value"], 80, "<br />", false);
                                        ?>
                                        <td style="padding-left: 10px;"><?php echo $entry;?></td>
                                        <?php
                                            }
                                        }
                                        ?>
                                    </tr>
                                </table>
                            <?php
                                }
                            }
                        }
                    }
                            ?>
                            </td>
                        </tr>
                </table>
            </div>
        </div>
    </body>
</html>