Warning: mysql_num_rows() expects parameter 1
Posted: Thu Oct 29, 2009 11:40 am
When i add quote at the end of this link
example:http://localhost/articlemania/category.php?cid=3"
it's give me an error
here is :
"
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\articlemania\category.php on line 42"
here is my code:
example:http://localhost/articlemania/category.php?cid=3"
it's give me an error
here is :
"
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:\wamp\www\articlemania\category.php on line 42"
here is my code:
Code: Select all
<?php
include("inc/connection.php");
include_once("inc/functions.php");
$cat_id = $_GET['cid'];
$select_page_title = ("SELECT cat_name FROM category WHERE cat_id = '$cat_id'");
$querying_page_title = mysql_query($select_page_title);
$fetching_page_title = mysql_fetch_assoc($querying_page_title);
?>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title><?php echo "Article Mania - {$fetching_page_title['cat_name']}"; ?></title>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<link href="inc/style.css" rel="stylesheet" type="text/css">
</head>
<body>
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><?php include("inc/header.php"); ?> </td>
</tr>
</table>
<table border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td align="left" valign="top"><?php include("inc/left.php"); ?> </td>
<!-- Main Conent Area Start here -->
<td align="left" valign="top"><table width="506" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td valign="top"><?php echo "------> {$fetching_page_title['cat_name']}"; ?><br /><img src="inc/images/main_content_area.gif" alt="main content" width="506" height="33"></td>
</tr>
<tr>
<td class="mcbg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td width="1"> </td>
<td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<?php
if(intval($cat_id) <= 0 && is_string($cat_id)){
common_error("Invalid category specified");
exit();
} else {
$select_article_indivisual = ("SELECT * FROM article where cat_id = \"$cat_id\" ORDER BY article_id DESC");
$querying_article_indivisual = mysql_query($select_article_indivisual);
$select_article_indivisual_rows = mysql_num_rows($querying_article_indivisual);
if($select_article_indivisual_rows <= 0){
common_error("No article available at this time");
exit();
} else {
while($retrieve_article_indivisual = mysql_fetch_assoc($querying_article_indivisual)){
echo "<tr>
<td bgcolor=\"#E8E8E8\" class=\"style2\"><font size=\"2\" face=\"Arial, Verdana, Helvetica, sans-serif\"><a href=\"article.php?aid=$retrieve_article_indivisual[article_id]\" alt=\"$retrieve_article_indivisual[article_title]\"><b><u>$retrieve_article_indivisual[article_title]</u></b></a></font></td>
</tr>
<tr>
<td><font face=\"Arial, Verdana, Helvetica, sans-serif\" size=\"2\"><br />".shortstring($retrieve_article_indivisual['article_text'])."<br /></font></td></tr>
<tr>
<td><font size=\"1\"> </font></td></tr>
<tr>
<td bgcolor=\"#E8E8E8\"><span class=\"style2\"><hr><font size=\"2\" face=\"Arial, Verdana, Helvetica, sans-serif\"><b>Posted Date: $retrieve_article_indivisual[article_date] | Category: <a href=\"category.php?cid=$retrieve_article_indivisual[cat_id]\" alt=\"$retrieve_article_indivisual[cat_name]\">".ucwords($retrieve_article_indivisual['cat_name'])."</a></b></font></span><br />
<hr>
</td>
</tr>";
}
}
}
?>
<!-- Copyright start Here
<tr>
<td class="crbg"><div align="center"><font size="1">© 2005 - <strong><a href="http://www.zymic.com"><font color="#208226">Free Templates</font></a> <font color="#00F43E"><a href="http://www.zymic.com">By
<font color="#208226">Zymic.com</font></a></font></strong> - Content by your <strong>site name</strong> - 100% Valid HTML 4.01 Transitional!</font></div></td>
</tr>
-->
</table></td>
<!-- Main Content Area end here -->
</tr>
</table>
</body>
</html>