Vfrdtyky

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

   }



 }