[SOLVED] MySql Error

[MrBillybob]

<?php

if ($row['refType'] == "Market Transaction") {
$sql = 'SELECT * FROM `eve_wallet_t` WHERE `transID` = ' . $row['argName1'] . '';
$result4 = mysql_query($sql);
if (!$result4) {
	// put he transaction link here
	$out1 = mysql_result($result4, 0, "transID");
	$out2 = mysql_result($result4, 0, "quantity");
	$out3 = mysql_result($result4, 0, "type");

	echo "<a href=\"".$thinout."\">" . $thinout2 . "x" . $thinout3 . "</a>";
}else{
	echo $row['argName1'];
}
}else{
echo $row['argName1'];
}
?>

 

Error:

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 82 in /home/content/t/u/b/tubguys/html/eve/index.php on line 726

 

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 82 in /home/content/t/u/b/tubguys/html/eve/index.php on line 727

 

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 82 in /home/content/t/u/b/tubguys/html/eve/index.php on line 728

 

Explanation:

This $row['argName1'] does not exist on this row i want to know how i can skip it. $row['argName1'] can equal a number or a word. If its a word then i want to skip it.. but if $row['refType'] == "Market Transaction" then it will equal a number...so

[Barand]

Warning: mysql_result(): Unable to jump to row 0 on MySQL result index 82 in /home/content/t/u/b/tubguys/html/eve/index.php on line 726

 

row 0 is the first row of the returned results. If your query doesn't find any matching rows then it can't go to row 0. Hence the error.

 

Use mysql_num_rows() first to check you have results.

 

if (!$result4) {

This will execute the following code if there is a query error

[MrBillybob]

thank you