<?php
mysql_connect("localhost", "user", "password") OR die ("Connection Error to Server");
mysql_select_db("database") OR die("Connection Error to Database");
 
if ($action=="submit")
mysql_query("INSERT INTO guests SET message='$message', guest='$guest', date=NOW()");
 
// Now select all the data, and print it one by one.
 
$result=mysql_query("SELECT * FROM guests");
while($row=mysql_fetch_array($result))
print $row['writer']." : ".$row['message']." on ".$row['date']."<hr align=left width=100>";
?>
 
<form method="post" action="<?=$PHP_SELF?>">
Name:<br>
<input type="text" name="guest">
<br>
Message:<br>
<textarea name="message"></textarea>
<br>
<input type="submit" name="action" value="submit">
</form>