Now all this new code does is show this...
warbz18.aexwow.com/comment.php
heres the code...
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <title>Comment</title> </head> <html> <body> <;? $dbHandle = sqlite_open('database.sqlite2', 0666, $sqliteError) or die($sqliteError); if (isset($_POST['button'])){ $username = (isset($_POST['username'])) ? $_POST['username'] : ''; $comment = (isset($_POST['comment'])) ? $_POST['comment'] : ''; $sqlCreateTable = 'CREATE TABLE commenttable(id INTEGER PRIMARY KEY, username CHAR(256), comment CHAR(256))'; @sqlite_exec($dbHandle, $sqlCreateTable); $sqlInsertComment = 'INSERT INTO commenttable (username, comment) VALUES (\''.$username.'\', \''.$comment.'\')'; sqlite_exec($dbHandle, $sqlInsertComment); } ?><form action="<;?php echo $_SERVER['PHP_SELF']; ?>" method="post" name="commentform" > Name: <input type="text" name="username"><br/> Comment: <textarea name="comment"></textarea><br/> <input type="submit" name="button" value="submit"></form><table><;? $query = sqlite_query($dbHandle, "SELECT id, username, comment FROM commenttable ORDER BY id DESC"); while ($entry = sqlite_fetch_array($query, SQLITE_ASSOC)) { ?><tr> <td> <;? echo $entry['username']; ?> says </td> <td> "<;? echo $entry['comment']; ?>" </td></tr><;? } ?> </body> </html>
Any help in making it work would be appreciated