Odtnhj

The idea behind the code below is to make a "Unfollower alert" for Twitch users/streamers.. The concept: Twitch api gives me a list of current followers of a channel which in my code if i find a new name I put him in the database under follower name and the same for follow time. My problem: I can`t get the sql code to understand and compare the current followers with the database and display the follower which is missing from the api but not in the database.

 <?php
 $connection = new mysqli("localhost","root","","twitchun");
 $channelsApi = 'https://api.twitch.tv/helix/users/follows? 
 to_id=176714165&first=10';
 $channelName = '';
 $clientId = 'pm7oxir9hxzhrl0hnzdxdrg';
 $ch = curl_init();
 curl_setopt_array($ch, array(
 CURLOPT_HTTPHEADER => array(
 'Client-ID: ' . $clientId
 ),
 CURLOPT_RETURNTRANSFER => true,
 CURLOPT_URL => $channelsApi . $channelName
 ));
 $response = curl_exec($ch);
 curl_close($ch);
 //echo $response;
 $json = json_decode($response, true);
 foreach ($json['data'] as $names)

 echo '<p>'.$names['from_name'].'</p>';




 foreach ($json['data'] as $names)
 $result = $connection->query("SELECT follower_name FROM followers WHERE 
 follower_name = '".$names['from_name']."'");
 if($result->num_rows == 0) 
 //if follower doesnt exist in database put him in
 mysqli_query($connection, 'INSERT into followers(follower_name, 
 follow_time) VALUES ("'.$names['from_name'].'", 
 "'.$names['followed_at'].'")'); 
 else 
 //if follower exists in database and in json
 

part where it doesnt work

 $fnames= $names['from_name'];
 $result2 = $connection->query("SELECT follower_name FROM followers WHERE 
 follower_name <> '".$fnames."' order by follow_time desc");

 $unfollow = mysqli_fetch_assoc($result2);
 foreach($unfollow as $unfollower)
 echo '<p style="color:red">'.$unfollower.'</p>';