sql code

<div id="wrapperbody">
	<?php
		if(isset($_GET["action"])){
		$userid = (int)$_GET["action"];
		$userid = mysqli_real_escape_string($mysqli, $userid);
			
		if($exec = $mysqli->query("SELECT * FROM `users` WHERE id='$userid'")) {
			$count = mysqli_num_rows($exec);
				while($user = $exec->fetch_assoc()) {
					$username = $user['username'];
					$avatar = $user['avatar'];
					$fouten = $user['fouten'];
					$rank = $user['rank'];
					$liefde = $user['liefde'];
					$posts = $user['posts'];
					$clan = $user['clan'];
					$up = $user['up'];
					$userid2 = $user['id'];
					$userid2 = mysqli_real_escape_string($mysqli, $userid2);
					$up = mysqli_real_escape_string($mysqli, $up);
					$clan = mysqli_real_escape_string($mysqli, $clan);
					$posts = mysqli_real_escape_string($mysqli, $posts);
					$liefde = mysqli_real_escape_string($mysqli, $liefde);
					$username = mysqli_real_escape_string($mysqli, $username);
					$avatar = mysqli_real_escape_string($mysqli, $avatar);
					$fouten = mysqli_real_escape_string($mysqli, $fouten);
					$rank = mysqli_real_escape_string($mysqli, $rank);
					
					if($exec2 = $mysqli->query("SELECT name FROM `rank` WHERE id='$rank'")) {
				while($user = $exec2->fetch_assoc()) {
					$name = $user['name'];
					$name = mysqli_real_escape_string($mysqli, $name);
				}
				}
					
					if ($count > 0){
					  //user bestaat al
					  ?>
						<div class="content">
							<h2>Profiel van <?php echo $username; ?></h2>
							<div class="body">
								<img src="<?php echo $avatar; ?>" style="height:100px; width:100px;" >
								<table>
									<thead>
										<tr>
											<th scope="col" abbr="Starter">UP</th>
											<th scope="col" abbr="Medium">Clan</th>
											<th scope="col" abbr="Business">Posts</th>
											<th scope="col" abbr="Deluxe">Likes</th>
											<th scope="col" abbr="Deluxe">Rank</th>
											<th scope="col" abbr="Deluxe">Fouten</th>
										</tr>
									</thead>
									<tbody>
										<tr>
											<td><?php echo $up; ?></td>
											<td><?php echo $clan; ?></td>
											<td><?php echo $posts; ?></td>
											<td><?php echo $liefde; ?></td>
											<td><?php echo $name; ?></td>
											<td><?php echo $fouten; ?></td>
										</tr>
									</tbody>
							  </table>
							</div>
						</div>
						
						<div class="content">
							<h2>Over mij</h2>
							<div class="body">
								
							</div>
						</div>
						
						<div class="contentprofiel">
							<div class="content2" style="margin-right:20px; float:left;">
							<h2>Topics</h2>
								<div class="body">
									<?php
										if($exec = $mysqli->query("SELECT * FROM `topics` WHERE ownerid='$userid'")) {
													while($rij = $exec->fetch_assoc()) {
														$id = $rij['id'];
														$name = $rij['name'];
														
														$id = mysqli_real_escape_string($mysqli, $id);
														$name = mysqli_real_escape_string($mysqli, $name);
														
														echo '<li><a href="/topic/'.$id.'">'.$name.'</a></li>';
													}
												}
									?>
								</div>
							</div>
							
							<div class="content2" style="float:right;">
							<h2>Reacties</h2>
								<div class="body">
									Deze gebruiker bestaat niet (meer).
								</div>
							</div>
						</div>
						<?php
					}
					else {
					  //user bestaat niet
					   echo '
						<div class="content">
							<h2>error</h2>
							<div class="body">
								Deze gebruiker bestaat niet (meer).
							</div>
						</div>
						';
					}
				}
			
		} else {
			echo '
			<div class="content">
				<h2>error</h2>
				<div class="body">
					Deze gebruiker bestaat niet (meer).
				</div>
			</div>
			';
		}
		} else {
		echo '
						<div class="content">
							<h2>error</h2>
							<div class="body">
								Deze gebruiker2 bestaat niet (meer).
							</div>
						</div>
						';
						}
	?>
</div>

echo '
		<div class="content">
			<h2>RE: '.$name.'</h2>
		<div class="body">
							<div class="info">
								<a style="color:'.$rankcolor.'" href="/profiel/'.$userid.'"><b>'.$username.'</b></a></br>
								<img src='.$avatar.' style="height:100px; width:100px;" /></br>
								<a href="URL" onclick="window.open(\'pages/liefde.php?action='.$userid.'\', \'Liefde geven\', \'width=250,height=300\'); return false"><img src="assets/img/icon/like.png" style="height:20px;"></a></br>
								UP: '.$up.'</br>
								Clan: '.$clan.'</br>
								Posts: '.$posts.'</br>
								Likes: '.$liefde.'</br>
								Rank: '.$rankname.'</br>
								Fouten: '.$fouten.'</br>
							</div>
							
						<div style="color:#525252; font-size:9px; margin-left:110px;">Geplaatst op: '.$date.'</div>
								<div class="topicheadcontent">'.$content.'</div></br>
								<div class="topicheadcontent" style="border-top:1px solid #CCCCCC;">'.$signature.'</div>
								<div style="clear:both;"></div>		
		</div>
		</div>
';