[UPHPU] Warning: mysql_result(): Unable to jump to row...

[Jonathan Grotegut]

I am getting this warning on my page: Warning: mysql_result(): Unable
to jump to row... (DKP site I mentioned in my last question).  I do
not have all the data in the system yet so I am getting this warning. 
I would also like to prevent this from happening when a new user is
added with no information.  Any suggestions would be appreciated.

Here is the queries:

$query = "SELECT
	`drops`.`playerID`,
	`items`.`itemID`,
	`items`.`ItemName`,
	SUM(`items`.`dkpcost`) AS dkpspent,
	`drops`.`itemID`,
	`player`.`playerID`,
	`player`.`PlayerName`,
	`player`.`PlayerClass`,
	`drops`.`dropID`,
	`drops`.`raidID`
FROM
	`drops`
	Inner Join `items` ON `drops`.`itemID` = `items`.`itemID`
	Inner Join `player` ON `drops`.`playerID` = `player`.`playerID`
GROUP BY
	`player`.`PlayerName`
ORDER BY
	$order $sort";
	$result = mysql_db_query ("lgzwywj_wowdkp", $query);




$querydkpearned = "SELECT
	`player`.`playerID`,
	Sum(`raidattendence`.`PointsEarned`) AS `dkpearned`
FROM
	`player`
	Inner Join `raidattendence` ON `player`.`playerID` =
`raidattendence`.`playerID`
GROUP BY
	`player`.`playerID`";
$resultdkpearned = mysql_db_query ("lgzwywj_wowdkp", $querydkpearned);




The php for this looks like this:

$numOfRows = mysql_num_rows ($result);
  for ($i = 0; $i < $numOfRows; $i++){
$playername = mysql_result ($result, $i, "PlayerName");
$dkpspent = mysql_result ($result, $i, "dkpspent");
$playerid = mysql_result ($result, $i, "playerID");
$playerclass = mysql_result ($result, $i, "PlayerClass");
if (mysql_result ($resultdkpearned, $i, "dkpearned")!= ""){$dkpearned
= mysql_result ($resultdkpearned, $i, "dkpearned");} else {$dkpearned
= "0";}
$dkptotal = $dkpearned - $dkpspent;



Any suggestions would be greatly appreciated on how to get rid of this warning.

You can see the page at http://beta.penumbra-guild.com and then click
on "View Players" at the top.

I am sure the code is sloppy, sorry I am just learning :-/

TIA

Jonathan Grotegut