PHP sql query not working

[Joveice]

Hello.

 

So I'm trying to get my usernames from my database but this returns nothing.

 

$data = $mysqli->prepare('SELECT username FROM game_profiles WHERE for_game=? AND platform=?');

        /* bind parameters for markers */
        $service = 'r6s';
        $data->bind_param('ss', $service, $platform);

        $data->bind_result($users);

        $data->fetch();
        /* execute query */
        $data->execute();

and I tryed a while $row = $users and echo the names but it dident work. 

 

So what did I do wrong? I'm not quite sure this is the correct way to do the query as I'm new to prepered statment in oop php.

[Hazy125]

prepare > bind > execute > bind_result > fetch

[Joveice]

15 minutes ago, Hazy125 said:

prepare > bind > execute > bind_result > fetch

Thanks!