RevCMS homes (what's my fault?)

[Goodbook]

Hi, got a tut from this link
http://forum.ragezone.com/f353/revcm...-homes-874946/
Now i got:


This is what i need

<?php

$username = $_REQUEST["user"];
$userid = $_REQUEST["id"];

// User Info \\
$userinfo = mysql_query("SELECT * FROM users WHERE username='$username' or id='$userid'");
$get2 = mysql_fetch_assoc($userinfo);

$user = $get2['username'];
$id = $get2['id'];
$looks = $get2['look'];
$email = $get2['mail'];
$rank = $get2['rank'];
$motto = $get2['motto'];
$credits = $get2['credits'];
$pixels = $get2['activity_points'];
$pvip = $get2['vip_points'];
$online = $get2['online'];

?>

<?php
//Stats\\

$stats = mysql_query("SELECT * FROM user_stats WHERE id='$id'");
$get1 = mysql_fetch_assoc($stats);
$resp = $get1['Respect'];
$giftr = $get1['GiftsReceived'];
$gifts = $get1['GiftsGiven'];
$achivement = $get1['AchievementScore'];
$visits = $get1['RoomVisits'];



?>
<?php echo $username; ?>
<?php echo $motto; ?>
<?php echo $email; ?>
<?php echo $credits; ?>
<?php echo $pixels; ?>
<?php echo $pvip; ?>
<?php echo $resp; ?>
<?php echo $gifts; ?>
<?php echo $giftr; ?>
<?php echo $achivement; ?>
<?php echo $visits; ?>
<?php

$getmybadges = mysql_query("SELECT * FROM user_badges WHERE user_id='$id'");

while($rowing = mysql_fetch_assoc($getmybadges)){
$badge = $rowing['badge_id'];
echo '<img src="r63/c_images/album1584/'.$badge.'.gif" style="margin-right: 10px;" />';

}
?>
<img src="http://habbo.com/habbo-imaging/avatarimage?figure=<?php echo $looks; ?>&head_direction=3&action=wlk,wav,drk=0,crr=3" alt="<php echo $username; ?>"  />
<?php
	
$getUser = mysql_query("SELECT * FROM users WHERE id ='$id'");
$user = mysql_fetch_array($getUser);

$rankId = $user['rank'];
$getRank = mysql_query("SELECT * FROM ranks WHERE id ='$rankId'");
$rank = mysql_fetch_array($getRank);

echo "".$rank['name']." (".$rank['id'].")";
?>
<?php
            $query = mysql_query("SELECT * FROM messenger_friendships WHERE user_one_id = '$id'");
            $i = 0;
            while($friends = mysql_fetch_array($query))
            {
                $getfriend = mysql_query("SELECT * FROM users WHERE id ='".$friends['user_two_id']."' LIMIT 1");
                if(mysql_num_rows($getfriend) > 0)
                {
                    $i++;
                    if($i == 1)
                    {
                     
                        echo '';
                    }
                    $friend = mysql_fetch_array($getfriend);
		$friendname = $friend['username'];
echo "<a href='index.php?url=home&user=$friendname'>";
echo htmlspecialchars($friend['username']).'</a>, ';
                }
            }
            if($i > 0)
echo '</br>'?>

How can i fix it or what is my fault?

Any help?

[MentaL]