Untitled

<!DOCTYPE html>
<html>
    <head>
        <meta charset="utf-8">
        <title>MovieClub Movie Index</title>
        <style>
            table, th, td {
                 border: 1px solid black;
            }
        </style>
    </head>
    <body>

        <h1>Movie Club Database Index</h1>
        <div>

        </div>
        <div>
            <table>
                <tr><th>ID</th><th>Title</th><th>Director</th><th>Producer</th><th>Release_Date</th><th>Running_Time</th><th>Genre</th><th>Starring</th><th>Distributor</th></tr>
                <?php
                    $servername = "localhost";
                    $username = "root";
                    $password = "";
                    $database="movieclub";

                    // Create connection
                     $conn = mysql_connect($servername, $username,$password,$database);

                    // Check connection
                     if (!$conn) {
                         die("Connection failed: " .mysql_connect_error());
                    }
                    //successful connection,

                    print_r(mysql_error($conn));


                    $sql = "SELECT * FROM movies";

                    $result = mysql_query($sql,$conn);

                    if (is_object($result) && $result->num_rows > 0){

                        // output data of each row
                        while($row = $result-> mysql_fetch_assoc()) {
                            echo "<tr> <td> " . $row['ID']. "</td> <td> " . $row['Title']. "</td> <td> " . $row['Director']. "</td><td> " . $row['Producer']. "</td><td> " . $row['Release_Date']. "</td><td> " . $row['Running_Time']. "</td><td> " . $row['Genre']. "</td><td> " . $row['Starring']. "</td><td> " . $row['Distributor']. "</td> </tr>";                        }
                    }
                    else {
                        echo "0 results";
                    }
                    mysql_close($conn);
                ?>
            </table>
        </div><br>
        <div>
    </html>