Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

News System.

Status
Not open for further replies.
Job Accomplished!
Joined
Jul 7, 2006
Messages
294
Reaction score
0
I installed Rose News System and I get this errors.

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/user/domains/public_html/folder/settings.php on line 29
(Red Line is Line 29)

function nbnews()
{
$regstart = mysql_query("SELECT count(*) As regnbr FROM $this->mytable");
$regnbr1 = mysql_fetch_array($regstart);
$nbrend = $regnbr1['regnbr'];
return ceil($nbrend / $this->mynews);
}

-------------------------------------------------------

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/user/domains/public_html/folder/settings.php on line 39
(red line is line 39)

function display($nbrp)
{
if (isset($_GET['p'])) { $p = $_GET['p']; } else { $p = 1; }
$first = ($p - 1) * $this->mynews;
$query = mysql_query('SELECT * FROM '.$this->mytable.' ORDER BY id DESC LIMIT '.$first.','.$this->mynews);
while ($res = mysql_fetch_array($query)) {
echo '
<tr bgcolor="FFFFFF" onMouseOver="this.style.background=\'#F3F3F3\'" onMouseOut="style.background=\'White\'"\');" onClick="selectcode(\''.$res['id'].'\');" style="cursor:hand;">
<td width="10%" height="26"><div align="center"><font color="#565656">'.$res['id'].'</font></div></td>
<td><font color="#565656">'.$res['title'].'</font></td>
<td width="15%"><div align="center"><font color="#565656">'.$res['date'].'</font></td>
<td width="10%"><div align="center"><font color="#565656">'.$res['hit'].'</font></td>
<tr><td height="1" colspan="4" bgcolor="#D3D3D3"></td></tr>
</tr>';
}
}


Thank you.
 
Status
Not open for further replies.
Back
Top