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.
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.