mysql_fetch_array ins't valid

[Paragon]

I keep getting this error.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/plugins/clandisplay.php on line 15

	include('config.php');

mysql_connect("$host","$username","$userpass");
mysql_select_db("$userdatabase");

$clanview = mysql_query("SELECT * FROM $rankprefix ORDER BY rnum");
while($r=mysql_fetch_array($clanview))
{   
$rank=$r["rank"];     
$info=$r["info"];
$rnum=$r["rnum"];
$memberview = mysql_query("SELECT * FROM $userprefix ORDER BY dlevel");
while($row=mysql_fetch_array($memberview))
{
$vampname=$row["userid"];
$dlevel=$row["dlevel"];
}
if($rnum==1){
echo "$rank";
echo "<br>";
echo "$info";
echo "<br>";
} 
if($dlevel==1){
echo "$vampname";
echo "<br>";
}
}

Anyone have any clue as to why?

Thanks for any help at all.

[uniflare]

well its $clanview or $memberview that is the problem, execute the mysql_query() function with the query nad put and die() function there like this:

mysql_query("SELECT * FROM $rankprefix ORDER BY rnum") or die(mysql_errno().": ".mysql_error());

and also do with the other query:

mysql_query("SELECT * FROM $userprefix ORDER BY dlevel") or die(mysql_errno().": ".mysql_error());

[Paragon]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/vampclan/public_html/plugins/clandisplay.php on line 9

include('config.php'); 

mysql_connect("$host","$username","$userpass"); 
mysql_select_db("$userdatabase"); 

mysql_query("SELECT * FROM $rankprefix ORDER BY rnum") or die(mysql_errno().": ".mysql_error());
while($r=mysql_fetch_array($clanview)) 
{    
$rank=$r["rank"];      
$info=$r["info"]; 
$rnum=$r["rnum"]; 
mysql_query("SELECT * FROM $userprefix ORDER BY dlevel") or die(mysql_errno().": ".mysql_error()); 
while($row=mysql_fetch_array($memberview)) 
{ 
$vampname=$row["userid"]; 
$dlevel=$row["dlevel"]; 
} 
if($rnum==1){ 
echo "$rank"; 
echo "<br>"; 
echo "$info"; 
echo "<br>"; 
}  
if($dlevel==1){ 
echo "$vampname"; 
echo "<br>"; 
} 
} 

I tried this as well.

	include('config.php');

mysql_connect("$host","$username","$userpass");
mysql_select_db("$userdatabase");

$clanview = "SELECT * FROM $rankprefix ORDER BY rnum";
$clanquery = mysql_query($clanview) or die(mysql_error()); 
while($r=mysql_fetch_array($clanview))
{   
$rank=$r["rank"];     
$info=$r["info"];
$rnum=$r["rnum"];
if($rnum==1){
echo "$rank";
echo "<br>";
echo "$info";
echo "<br>";
} 
}
mysql_connect("$host","$username","$userpass");
mysql_select_db("$userdatabase");

$memberview = "SELECT * FROM $userprefix ORDER BY dlevel";
$memberquery = mysql_query($memberview) or die(mysql_error());
while($r=mysql_fetch_array($memberview))
{
$vampname=$r["userid"];
$dlevel=$r["dlevel"];
}
if($dlevel==1){
echo "$vampname";
echo "<br>";
}

[Paragon]

resolved

Why do I have to do it that way ?

Thanks for the help btw

[uniflare]

please share the solution... i dont see what you have done to correct it, just gave incorrect code?

btw your welcome 😉