PHP Script error

[Adiko]

Hello, i made some script but im getting error with that.

<?php
	#CONFIG
	$host = 'xxx'; // Host
	$user = 'xxx'; // User
	$pass = 'xxx'; // Pass
	$db = 'xxx'; // Database
	#CONFIG END

	$sql = mysql_connect($host, $user, $pass);
	mysql_select_db($db);

	# 12.01.10 6:25 - 13.01.10 16:00
	$mniejsze_od = mktime(16, 0, 0, 1, 13, 2010); 	
	$wieksze_od = mktime(6, 25, 0, 1, 12, 2010);

	$players = array();
	
	$q = mysql_query('SELECT trans_start, to_name, price FROM shop_history_item WHERE trans_start < '.$mniejsze_od.' AND trans_start > '.$wieksze_od);
	while($r = mysql_fetch_array($q, MYSQL_ASSOC)) {
		$players[$r['to_name']] += $r['price'];
	}

	foreach($players as $key => $value) {
		$x = mysql_query('SELECT points FROM players WHERE name = \''.$key.'\'');
		$x = mysql_fetch_array($x, MYSQL_ASSOC);
		$x = $x['points'];
		
		mysql_query('UPDATE players SET points = '.($value+$x).' WHERE name = \''.$key.'\'');
	}
?>

Error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /xxx/xxx/xxx/xxx/kasa.php on line 19

 

[Xampy]

Try (not tested):

<?php
    #CONFIG
    $host = 'xxx'; // Host
    $user = 'xxx'; // User
    $pass = 'xxx'; // Pass
    $db = 'xxx'; // Database
    #CONFIG END

    $sql = mysql_connect($host, $user, $pass);
    mysql_select_db($db);

    # 12.01.10 6:25 - 13.01.10 16:00
    $mniejsze_od = mktime(16, 0, 0, 1, 13, 2010);     
    $wieksze_od = mktime(6, 25, 0, 1, 12, 2010);

    $players = array();
    
    $q = mysql_query('SELECT trans_start, to_name, price FROM shop_history_item WHERE trans_start < '.$mniejsze_od.' AND trans_start > '.$wieksze_od.'');
    while($r = @mysql_fetch_array($q, MYSQL_ASSOC)) {
        $players[$r['to_name']] += $r['price'];
    }

    foreach($players as $key => $value) {
        $x = mysql_query('SELECT points FROM players WHERE name = \''.$key.'\'');
        $x = @mysql_fetch_array($x, MYSQL_ASSOC);
        $x = $x['points'];
        
        mysql_query('UPDATE players SET points = '.($value+$x).' WHERE name = \''.$key.'\'');
    }
?>