Здравейте на този скрипт получавам ето тази грешка

Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in G:\xampp\htdocs\pvp5.php on line 27

Въпроса ми е как да го поправя

<?php

$mysql_link = mysql_connect("localhost", "root", "pass") or die ("Could not connect.");

mysql_select_db("characters", $mysql_link) or die ("Unknown DB.");

define('KILLS', 1244); // for 2.4.3 use 1517, for 3.0.3 use 1602

define('LEVEL', 53); // for 2.4.3 use 34, for 3.0.3 use 53

define('GENDER', 22); // for 2.4.3 use 36, for 3.0.3 use 22

function GetFaction($CharacterRace)

  {

    if($CharacterRace == 1 || $CharacterRace == 3 || $CharacterRace == 4 || $CharacterRace == 7 || $CharacterRace == 11)

        return "alliance";

    else

        return "horde";

  }

?>

<h3 align='center'>Top 20 PvP</h3>

<table align='center' border='1'>

<tr><th>Name</th>

<th align="center">Faction</th>

<th align="center">Race</th>

<th align="center">Class</th>

<th align="center">Level</th>

<th align="center">Kills</th></tr>

<?php

$pvpquery = mysql_query("SELECT `data`, `name`, `race`, `class` FROM `characters`

 WHERE CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) >0 

 ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) DESC LIMIT 20");

while($chardata = mysql_fetch_assoc($pvpquery)){

	$char_data = explode(' ',$chardata["data"]);

	$char_gender = dechex($char_data[GENDER]);

	$char_gender = str_pad($char_gender,8, 0, STR_PAD_LEFT);

	$char_gender = $char_gender{3};

	echo "<tr><td>".$chardata["name"]."</td>\n";

	$thisFaction = GetFaction($characters["race"]);

	echo "<td align=\"center\"><img width=\"20\" height=\"20\" src=\"".$thisFaction.".gif\"></td>";

	echo "<td align=\"center\"><img src=\"race/".$chardata["race"]."-".$char_gender.".gif\"></td>\n";

	echo "<td align=\"center\"><img src=\"class/".$chardata["class"].".gif\"></td>\n";

	echo "<td align=\"center\">".$char_data[LEVEL]."</td>\n";

	echo "<td align=\"center\">".$char_data[KILLS]."</td></tr>\n";

}

?>

</table>



<h3 align='center'>Top 5 Arena Team Rating</h3>

<table border="1" align="center">

    <tr>

        <th>Arena Team name</th>

        <th>Arena Rating</th>

        <th>Games</th>

        <th>Wins</th>

    </tr>

<?php

$user = 'root'; // mysql user name

$pass = 'pass'; // mysql password

$characters = 'characters'; // name of the characters database

$ip = 'localhost'; // host address

$limit = '5'; //how many player to show

$connect = mysql_connect($ip, $user, $pass) or die ("Cant connect ".$ip);

mysql_select_db($characters, $connect) or die ("Cant connect ".$characters);

$result = mysql_query("SELECT `at`.`name`, `ats`.`rating`, `ats`.`games`, `ats`.`wins` FROM arena_team at, arena_team_stats ats WHERE `at`.`arenateamid`= `ats`.`arenateamid` ORDER BY `rating` DESC LIMIT $limit") or die(mysql_error());

while ($vystup = mysql_fetch_assoc($result))

{

?>

    <tr>

        <td align="center"><?php echo $vystup["name"] ?></td>

        <td align="center"><?php echo $vystup["rating"] ?></td>

        <td align="center"><?php echo $vystup["games"] ?></td>

        <td align="center"><?php echo $vystup["wins"] ?></td>

    </tr>

<?php

}

?>

</table>

<?php

$pvpQueryStr = "SELECT `data`, `name`, `race`, `class` FROM `characters`

WHERE CAST( SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) >0

ORDER BY CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(`data`, ' ', ".(KILLS+1)."), ' ', -1) AS UNSIGNED) DESC LIMIT 20";

echo $pvpQueryStr;

$pvpquery = mysql_query($pvpQueryStr);

привет,

изглежда mysql_query е върнало false, виж така какво пише в $pvpQueryStr и същото го изпълни в phpmyadmin или който mysql client ползваш. би трябвало да ти даде грешка, която да поправиш и след това да си промениш заявката

поздрави

нас