mySQL check for match in database (array) Options

[sanoj96]

Hello,

So i have had this script going for a while, not noticing anything since it have given me an output. But yesterday i noticed that some useres had was missing on the list.

So i am trying to get all useres that has u_role 498147873003798539. The problem is that useres that has the role in the second place in the array like this : 123451232132131, 498147873003798539, 123154512555433 is getting displayed, but when it is in the 3rd or more position it wont display.


This is my code:

CODE

$array = array('498147873003798539'); //u_role to find in the array ('12345678910, 10987654321')
$sql = "SELECT * FROM userlist WHERE u_roles IN (".implode(',', $array).")"; //sql
$result = mysqli_query($db_conn, $sql); //sql
$array = mysqli_fetch_assoc($result); //sql

$exploded = explode(",", $array['u_roles']);
$gamers = [];
foreach ($exploded as $row){
    $query = "SELECT * FROM userlist WHERE u_roles = $row";

    $res = mysqli_query($db_conn, $query);
    $arr = mysqli_fetch_assoc($res);

    $gamers[] = $arr["u_roles"];
    while($test = mysqli_fetch_assoc($res)){
            if($test["u_nickname"] == "undefined"){
                echo "<p>Username: " .$test["u_name"]. "</p>";
                
            }else{
            //echo "id: " .$test["u_userid"]. "<br>";
            //echo "Name: " .$test["u_name"]. "<br>";
            echo "<p>Nickname: " .$test["u_nickname"]. "</p>";
            //echo "Role: " . $test["u_roles"];
            }
    }
}

it is proberly a easy fix, but for some reason i cant find the problem, any help will be appriciated.