<?php

        $host = 'localhost';
        $user = 'jdgoode';
        $passwd = 'vwccsjdgoode';
        $database = 'jdgoode';

        $connect = mysql_connect($host, $user, $passwd);
        $query = "select * from SURVEY";
        print "The query is <i> $query </i> ";

        mysql_select_db($database);
        $result_id = mysql_query($query, $connect);

        if($result_id)
        {
                print '<table border=1>';
                print '<TH> Name <TH> Live <TH> Visit <TH> Comments <TH>';
                while($row = mysql_fetch_row($result_id))
                {       print '<TR>';
                        foreach ($row as $field)
                                print "<TD> $field </TD> ";
                        print '</TR>';
                }
        }
        else
                print "Fail.<p>";
        mysql_close($connect);

?>

        <CENTER>
        <input type=submit value="To main page">
        </CENTER>