<?php
try
{
        //open the database
        $db = new PDO('sqlite:music.db');
        $db->exec("DELETE from Music;");
        $db->exec("INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Whatd I Say', 'Ray Charles', '1956');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Smells Like Teen Spirit.', 'Nirvana', '1991');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Hey Jude', 'The Beatles', '1968');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Johnny B. Goode', 'Chuck Berry', '1958');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Good Vibrations', 'The Beach Boys', '1966');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Respect', 'Aretha Franklin', '1967');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Whats Going On', 'Marvin Gaye', '1971');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Imagine', 'John Lennon', '1971');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('(I Cant Get No) Satisfaction', 'Rolling Stones', '1965');" .
                    "INSERT INTO Music(Title, Author, ReleaseDate) VALUES ('Like A Rolling Stone', 'Bob Dylan', '1965');");


        //now output the data to a simple html table...
        //example of specifier  --> WHERE First=\'Josh\'; <--
        print "<table border=1>";
        print "<tr><td>Title</td><td>Author</td><td>Y.O.P.</td></tr>";
        $result = $db->query('SELECT * FROM Music ');
        foreach($result as $row)
        {
            print "<td>".$row['Title']."</td>";
            print "<td>".$row['Author']."</td>";
            print "<td>".$row['ReleaseDate']."</td></tr>";
            }
        print "</table>";

        $db = NULL;
        }
    catch(PDOException $e)
    {
        print 'Exception : '.$e->getMessage();
        }
    ?>

I am not sure why nothing is being inserted into the table. The file 'music.db' exists in the right path.

For the record, I can only use SQlite3, no SQL allowed. PHP is allowed, so is SQLite3.