Problem z skryptem

[Adiko]

Otóż napisałem pewien skrypt i coś chyba tu pomylilem ale nie mam juz pomyslu co więc potrzebuje pomocy ;/

<?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.'\'');
	}
?>

Błąd:

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

 

[trou]

   <?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) or die(mysql_error());
    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.'"') or die(mysql_error());
        $x = mysql_fetch_array($x, MYSQL_ASSOC);
        $x = $x['points'];
        
        mysql_query('UPDATE players SET points = '.($value+$x).' WHERE name = "'.$key.'"') or die(mysql_error());
    }
?>

bedzie info o bledach

 

[Adiko]

Niema zadnych dodatkowych błędów ;/

 

[Adiko]

ref

 

[trou]

to znaczy, ze zapytanie nic nie zwraca