Errors!!!

cralyn

Hi,

I am getting the following error from my script.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/cybercl/public_html/sermonarchives/index.php on line 28

Can anyone tell me what this means and how to fix it?

I have attached the entire script as a zip file.

bernouli

replace

if (mysql_num_rows($res)>0)

with

if (mysql_num_rows($sql)>0)

cralyn

I tried the changes but still get the same error message.

bernouli

how about when you save the query in a var, and then use the var again

$datarows = mysql_num_rows($sql);

if ($datarows>0)

cralyn

Still getting the same error message

bernouli

give me your line 28, so that i see you have wrote the right one

bernouli

and it should be so:

$datarows = mysql_num_rows($res);
if ($datarows>0)

cralyn

<?
require("admin/config.php3");
include("admin/connect.inc");
db_connect();
?>

<html>

<head>
<title>Index</title>
<LINK href="admin/images/style.css"
rel=stylesheet type=text/css>
</head>

<body>

<table border="0" width="100%" bordercolor="#C0C0C0" cellspacing="0" cellpadding="0" bgcolor="#9F0000">
<tr>
<td width="100%">
Articles</td>
</tr>
</table>
Article Listings:

<?
$sql="select * from article_main order by article_id desc";
$res=mysql_query($sql);
$datarows = mysql_num_rows($res);
if ($datarows>0)

{
?>
<ul>
<?
while ($myrow=mysql_fetch_array($res))
{
$articleid=$myrow[article_id];
$articlename=$myrow[article_title];
?>

<li>
<a href="readarticle.php?articleid=<?echo $articleid;?>"><?echo $articlename;?></a></li>
<?
}

?>
</ul>
<?
}
?>

</body>

</html>

bernouli

ive no more idea, try this at least

$sql = mysql_query("select * from article_main order by article_id desc");

$datarows = mysql_num_rows($sql);

if($datarows > 0)

bernouli

i hope you change your password, since you have attached all the file including connect.inc etc 😃