Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource, Potrzebna pomoc.. Opcje

[Soulast]

Proszę wybaczyć jeśli nie trafiłem dobrze..
Jestem początkującym koderem i staram się naprawiać błędy lecz nawet te proste nie wychodzą mi na dobre:)
Z tego co domyślam się problem wychodzi z braku danych w tabeli ladders ale nie do końca wiem jak to naprawić poza stworzeniem jakiego kol-wiek laddera..

a mam dokładnie taki problemik..

Wyskauje mi errror :

[PHP] pobierz, plaintext 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/***/theme/default/html.php on line 1363
[PHP] pobierz, plaintext 

a oto kod z podanej lini w której właśnie nie widze problemu :/

[PHP] pobierz, plaintext 
$laddern=mysql_query("SELECT name FROM ladders WHERE id='$currladderid'");
[PHP] pobierz, plaintext 

a oto część całego kodu:

[PHP] pobierz, plaintext 
<?
 
echo"
<table width='100%' align='center' border='0' cellspacing='0'>
<script type=\"text/javascript\"><!--
function reloadform(form)
{
var ladderid=form.top10ladderid.options[form.top10ladderid.options.selectedIndex].va
lue;
//document.getElementById('loading').style.display=\"block\";
self.location='"; echo "http://".$_SERVER["SERVER_NAME"].(substr($_SERVER["REQUEST_URI"], -3)=="php"||substr($_SERVER["REQUEST_URI"], -1)=="/"?$_SERVER["REQUEST_URI"]."?top10ladderid=' + ladderid":$_SERVER["REQUEST_URI"]."&top10ladderid=' + ladderid"); ;
echo"
}
//-->
</script>
<form id='top10' method='get'>";
unset($ladders);
if(empty($_GET['top10ladderid'])){
   $laddersql = mysql_query("SELECT id,name FROM ladders WHERE active=1 ORDER BY name ASC");
   while($l = mysql_fetch_assoc($laddersql))
      $ladders[] = $l;
   $infloop=0;
   do{
      $seed = rand(0,count($ladders)-1);
      $currladderid = $ladders[$seed]['id'];
      $rematch=mysql_query("SELECT teamid,name FROM ladder_".$currladderid." ORDER BY points DESC LIMIT 7");
      if($infloop >= count($ladders)*2) break;
      $infloop++;
   }while(mysql_num_rows($rematch) == 0);
   $ok = true;
}else{
   $ladders = mysql_fetch_assoc( mysql_query("SELECT id,name FROM ladders WHERE id=".$_GET['top10ladderid']) );
   $currladderid = $ladders['id'];
   $rematch=mysql_query("SELECT teamid,name FROM ladder_".$currladderid." ORDER BY points DESC LIMIT 7");
   $ok = (mysql_num_rows($rematch) > 0);
}
echo"<br/><tr><td colspan=2 align='center'>
<select name='top10ladderid' onchange=\"reloadform(this.form);\" class='button'>";
$laddersql = mysql_query("SELECT id,name FROM ladders WHERE active=1 ORDER BY name ASC");
while($l = mysql_fetch_assoc($laddersql))
   echo "<option value='{$l[id]}' ".($l['id']==$currladderid?'SELECTED':'').">{$l[name]}</option>";
 
 
echo "</select><br /><br /><a href='./standings.php?ladder[id]=".$currladderid."'><font color='red'>View Standings</font></a></td></tr>";
if($ok){
   while(list($teamid,$name)=mysql_fetch_row($rematch)){
      $laddern=mysql_query("SELECT name FROM ladders WHERE id='$currladderid'");
  $laddern=mysql_fetch_array($laddern);
   $max_length = 20;
   if (strlen($name) > $max_length){   
      $name = substr($name,0,$max_length);
      $name .= "..."; }   
   if($config[cellbgx]==$config[cellbg3]){$config[cellbgx]="$config[cellbg3]";}else{$config[cellbgx]="$config[cellbg3]";}
   echo"<tr><td align='center'><a href='./stats.php?account=$teamid'><span style='color:#FFFFFF;'>$name</span></a><br /><div class='smalltext'><i>$laddern[name]</i></div></td><td align='center'><a href='./challenge.php?login[cid]=$teamid'><img src='./theme/default/images/challenge.png' border='0'/></a></td></tr>";
   }
}else{
   echo"<tr><td align='center'><i style='color:#FFFFFF;'>No teams</i></td></tr>";
}
echo"</table></div><div class=\"bottomrighsidebar\"></div>";
 
		?>
[PHP] pobierz, plaintext 

z góry dziękuje za wszelką pomoc...

Ten post edytował Soulast 26.10.2009, 14:21:36