<?php
$dbhost = "localhost";
$dbuser = "benutzer";
$dbpw = "pw";
$dbname = "usr_web2_1";

mysql_connect($dbhost,$dbuser,$dbpw)

$sql = "SELECT * FROM gaestebuch";


if ( !$res_id = mysql_query($sql))
    die ('Fehler! SQL Befehl ist falsch');
    
    while ($test = mysql_fetch_array($res_id))
    {
    echo "<table>";
    echo  $test['Name']." ". $test['EMail']." ". $test['Thema']. " ". $test['Eintrag']." ". ;
	 echo "</table>"; 
    } 
?>

echo  $test['Name']." ". $test['EMail']." ". $test['Thema']. " ". $test['Eintrag']." ". ;

<form name="form1" method="post" action="abschicken.php">
              

Name: 
                <input type="text" name="Name">
                

                EMail: 
                <input type="text" name="EMail">
                

                Thema: 
                <input type="text" name="Thema">
                

                Ihr Eintrag: 
                <textarea name="Eintrag"></textarea>
                

              </p>
              

 
                <input type="submit" name="Submit" value="Abschicken">
              </p>
            </form>

abschicken.php

<?php
$dbhost = "localhost";
$dbuser = "benutzer";
$dbpw = "pw";
$dbname = "usr_web2_1";

mysql_connect($dbhost,$dbuser,$dbpw);
mysql_select_db($dbname);

$bla1 = $_POST['Name'];
$bla2 = $_POST['Email'];
$bla3 = $_POST['Thema'];
$bla4 = $_POST['Eintrag'];

$query = "insert into `gaestebuch`(`id`,`Name`,`EMail`,`Thema`,`Eintrag`)
VALUES
' ','$bla1','$bla2','bla3','bla4')";

mysql_query($query);


?>