Print API on database

[Emanuele_Capizzi]

I have a prolem:

	foreach(apichan() as $mydata){
		$name      = $mydata['user_name'];
		$views     = $mydata['viewer_count'];
		$game     = $mydata['game_id'];

	foreach(games() as $mygame){
		$game_id = $mygame['id'];
		$games = $mygame['name'];
		$thumbn = $mygame['box_art_url'];
	
	if(apichan() == FALSE){
	$noinlive = "UPDATE user_data SET inlive = 0 WHERE inlive = 1";
	$resultnolive = mysqli_query($connString, $noinlive)or die(mysqli_error());
	}else{}

	$controllo = "SELECT users_name FROM user_data WHERE users_name = '$name'";
	$resultnocon = mysqli_query($connString, $controllo)or die(mysqli_error());

	$controllogame = "SELECT game_id FROM game_name WHERE game_id = '$game_id'";
	$resultnogame = mysqli_query($connString, $controllogame)or die(mysqli_error());
	
	$update = "UPDATE user_data SET users_name = '$name', viewer_count = '$views', game_id = '$game', inlive = 1";
	$resultupdate = mysqli_query($connString, $update)or die(mysqli_error());

	$insert = "INSERT INTO user_data ( users_name, viewer_count, game_id, inlive ) SELECT * FROM (SELECT '$name', '$views', '$game', '1' ) AS tmp WHERE NOT EXISTS (SELECT users_name FROM user_data WHERE users_name = '$name')";
	$resultinsert = mysqli_query($connString, $insert)or die(mysqli_error());

	$insert2 = "INSERT INTO game_name ( game_id, nome, thumbn ) SELECT * FROM (SELECT '$game_id', '$games', '$thumbn' ) AS tmp WHERE NOT EXISTS (SELECT game_id FROM game_name WHERE game_id = '$game_id')";
	$resultinsert2 = mysqli_query($connString, $insert2)or die(mysqli_error());
	
		$delete = "DELETE FROM user_data WHERE inlive = 0";
		$resultdelete = mysqli_query($connString, $delete)or die(mysqli_error()); 
}}}

In this case my cron set inlive 0 correctly if array give no results, update correctly users on database and delete it if post-update inlive is 0, but insert soes’nt work, it insert only one.
What should i do?

[BarryCarlyon]

You have a nested call to apiChan()

Shouldn’t if(apichan() == FALSE){ be using $mydata

This just looks like a convoluted way to do this from a PHP programming side.

$noinlive = “UPDATE user_data SET inlive = 0 WHERE inlive = 1”;

this sets everyone to not live if live rather than just the user from $myData