<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>