Shoutbox

Im currently undertaking my first PHP task.. Making a ShoutBox..
So far i've pieced this together. Scott, could you tell me if it would? Possibly help me? (My server down ATM):

shout.php

<? require_once "db_connect.php"; ?>
<? require "inserting_data.php"; ?>

<form action=POST method=inserting_data.php>
<input name=name><br />
<input name=message>
</form>

$query="SELECT * FROM shoutbox";

$num=mysql_numrows($result);

$i=0;
while ($i < $num) {

$name=mysql_result($result,$i,name");
$message=mysql_result($result,$i,message");
?>


db_connect.php

<?
$user="";
$password="";
$database="localhost_test";
mysql_connect($database,$user,$password);
@mysql_select_db($database) or die( "Unable to select database");
$query="CREATE TABLE `shoutbox` (
`name` VARCHAR( 10 ) NOT NULL ,
`message` VARCHAR( 50 ) NOT NULL
)";
mysql_query($query);
mysql_close();
?>


inserting_data.php

$query = "INSERT into shoutbox VALUES (".'$name'.'$message')";


admin.php

<?
$user="";
$password="";
$database="";
mysql_connect($database,$user,$password);

$query="SELECT * FROM shoutbox WHERE name='$name'";
$result=mysql_query($query);
$num=mysql_numrows($result);
mysql_close();
?>