Selecting a variable

[Rasmus Christiansen]

Hi everyone.
I'm very new to all this PHP and MySQL, so i'm having a bit trouble.
I have a website were i have made a register and login system, and now i want to make a role system.
Right now i have some problems with selecting the variable role. (I just need to show the role variable number and not the role name). Can anyone figure this out for me?
Here's the code:
----SERVER.PHP------
if (count($errors) == 0) {
$password = md5($password);
$query = "SELECT * FROM rasmussw_users WHERE username='$username' AND password='$password'";
$results = mysqli_query($db, $query);
if (mysqli_num_rows($results) == 1) {
$results = mysqli_query($db, $query);
$user = mysqli_fetch_assoc($result);
$roleid = $user['roleid'];
$_SESSION['roleid'] = $roleid;
$_SESSION['username'] = $username;
$_SESSION['success'] = "Du er nu logget ind";
header('location: index.php');

----INDEX.PHP-----
<h5 class="col-md-6 col-sm-6" style="text-align: left;">Hej <?php echo $_SESSION['username'] . " " . $_SESSION['roleid']; ?></h5>