warning mysql_fetch_array

thegod · May 30, 2007

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in tops.php on line 33

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in tops.php on line 56

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in tops.php on line 76

i have point the lines out in red

this is tops coding

<?

session_start();

include "includes/functions.php";

logincheck();

$username=$_SESSION['username'];

include "includes/db_connect.php";

echo "$style";

?>

<title>Untitled Document</title>

</head>

<body>

<tr>

<td width="274" height="122" valign="top"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="<?php echo "$td_border"; ?>" bgcolor="#666666">

<tr>

<font color="#FFFFFF">Top 10 Ranks </center></td>

</tr>

<tr>

<td width="127" height="10" valign="top"><b>Username</b></td>

</tr>

<center><?php

$tsel = mysql_query("select * from `users` where `userlevel`='0' and `status`='alive' order by `rank` desc limit 10");

while ($top=mysql_fetch_array($tsel)) { line 36

print "<tr><td></center><a href=profile.php?viewuser=$top[username]>$top[username]</a></td><td align=right>$top[rank]</td></tr>";

}

?>

</table>

<br>

<tr>

<td width="200%" height="122" valign="top"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="<?php echo "$td_border"; ?>" bgcolor="#666666">

<tr>

<font color="#FFFFFF">10 Richest Players </center></td>

</tr>

<tr>

<td width="127" height="10" valign="top"><b>Username</b></td>

</tr>

<?php

$tsel = mysql_query("select * from `users` where `userlevel`='0' and `status`='alive' order by `money` desc limit 10");

while ($top = mysql_fetch_array($tsel)) { Line 56

print "<tr><td><a href=profile.php?viewuser=$top[username]>$top[username]</a></td><td align=right>$top[rank]</td></</tr>";

}

?>

</table>

<tr>

<td width="274" height="122" valign="top"><table width="100%" border="1" cellpadding="0" cellspacing="0" bordercolor="<?php echo "$td_border"; ?>" bgcolor="#666666">

<tr>

<font color="#FFFFFF">Top 10 Forum Posters </center></td>

</tr>

<tr>

<td width="127" height="10" valign="top"><b>Username</b></td>

<td width="136" valign="top"><b>Posts</b></td>

</tr>

<center><?php

$tsel = mysql_query("select * from `users` where `userlevel`='0' and `status`='alive' order by `posts` desc limit 10");

while ($top = mysql_fetch_array($tsel)) { line 76

print "<tr><td></center><a href=profile.php?viewuser=$top[username]>$top[username]</a></td><td align=right>$top[posts]</td></tr>";

}

?>

</table>

<br>

</td>

</table>

</body>

</html></center>

bubblegum.anarchy · May 30, 2007

Change this line:

<?php
   $tsel = mysql_query("select * from `users` where `userlevel`='0' and `status`='alive' order by `rank` desc limit 10");
while ($top=mysql_fetch_array($tsel)) { // line 36
      print "<tr><td></center><a href=profile.php?viewuser=$top[username]>$top[username][/url]</td><td align=right>$top[rank]</td></tr>";
   }
   ?>

To this:

<?php
   $tsel = mysql_query($query = "select * from `users` where `userlevel`='0' and `status`='alive' order by `rank` desc limit 10") or trigger_error(mysql_error()."<PRE>".$query."</PRE>", E_USER_ERROR);;
while ($top=mysql_fetch_array($tsel)) { // line 36
      print "<tr><td></center><a href=profile.php?viewuser=$top[username]>$top[username][/url]</td><td align=right>$top[rank]</td></tr>";
   }
   ?>

... and investigate the mysql error.

Sign In

warning mysql_fetch_array

Recommended Posts

thegod

Link to comment

Share on other sites

bubblegum.anarchy

Link to comment

Share on other sites

Archived

Browse

Activity

Important Information