//the host, name, and password for your mysql
mysql_connect("localhost","user","password");
//select the database
mysql_select_db("spoono_sections");
if($submit)
{
//use the PHP date function for the time
$time=date("h:ia d/j/y");
// inserting it into the shoutbox table which we made in the mysql statements before
$result=MYSQL_QUERY("INSERT INTO shoutbox (id,name,message,time)".
"VALUES ('NULL','$name', '$message','$time')");
}
?>
//returning the last 5 messages
$result = mysql_query("select * from shoutbox order by id desc limit 5");
//the while loop
while($r=mysql_fetch_array($result))
{
//getting each variable from the table
$time=$r["time"];
$id=$r["id"];
$message=$r["message"];
$name=$r["name"];
?>
echo $time ?>
echo $name ?>
echo $message ?>
} ?>