I have a guest book but when it completes, only the username and message part works (updates to database) however $yourname var dosn't get put into the table "name" on the database and think its this page because if I manually add a name in the table it shows up on the guest book view page,

any ideas please anyone, i have tried all kinds to no avail.
PS yes I am logged in, and not sure why it dosn't work as it should as the message gets in there along with the users name ($username) who the guestbook is for.


PHP Code:
<?php
session_start
();
?>

<html>
<head>
<title>J~Net Guestbook</title>
<link rel="stylesheet" type="text/css" href="../css/style.css" />
</head>

<?php
require 'database.php';
// include '../header.php';


 
$id $_SESSION['user_id'];
$_SESSION['user_id']= $id;
$yourname $_SESSION['user_name'];
$_SESSION['user_name']= $yourname;
        
// $_SESSION['user_name'] = $full_name;
        
$_SESSION['user_level'] = $user_level;
        
$_SESSION['HTTP_USER_AGENT'] = md5($_SERVER['HTTP_USER_AGENT']);
        
$_SESSION['session_name'] = $user_name;
        
$_SESSION['balance']= $balance;
 
// Connects to your Database 
 
mysql_connect("localhost""root""") or die(mysql_error()); 
 
mysql_select_db("messages") or die(mysql_error()); 
 
$data mysql_query("SELECT * FROM users where id = $id"
 or die(
mysql_error()); 
 while(
$info mysql_fetch_array$data )) 

 echo 
"<tr>"
 echo 
" <td>".$info['user_name'] . "</td> "
 } 
$username $_SESSION['visited_profile'];
$yourname $info["user_name"];
$message strip_tags($_POST['message']);

if (isset(
$_POST['submit']))
{
        if (!
$message)
    {
        echo 
"<P><center>Please Enter A Message!";
echo 
"$yourname";
        echo 
"<FORM><INPUT TYPE='button' VALUE='Go back' onClick='history.go(-1);return true;'> </FORM>";
        exit;
    }
    else{}
    
    
$query mysql_query("INSERT INTO guestbook (username, message, name) VALUES ('$username','$message','$yourname')") or die(mysql_error());

echo 
"<center>Your Message Was Posted Sucsessfuly!<br /><a href='guestbook.php?" $_SESSION['visited_profile'] . "'>Continue</a></center>";

}

?>