Warning: mysql_num_rows() expects parameter 1


Posted on 16th Feb 2014 07:03 pm by admin

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 :
Did you know?Explore Trending and Topic pages for more stories like this.
"
Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in C:wampwwwarticlemaniacategory.php on line 42"

here is my code:
Line number On/Off | Expand/Contract<?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 "------>&nbsp;&nbsp;{$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">&nbsp;</td><td><table width="100%" border="0" align="center" cellpadding="0" cellspacing="0"><?phpif(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">&nbsp;</font></td></tr><tr><td bgcolor="#E8E8E8"><span class="style2"><hr><font size="2" face="Arial, Verdana, Helvetica, sans-serif"><b>Posted Date:&nbsp;$retrieve_article_indivisual[article_date] | Category:&nbsp;<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">&copy; 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>
No comments posted yet

Your Answer:

Login to answer
178 Like 37 Dislike
Previous forums Next forums
Other forums

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

True way to see if action was successful?
If this is a good way to see if action was successful to continue:

Code: function changeGa

rdns with php
I am trying to build a script that will show all of the different domains that are hosted on the sam

Scene graph using Direct3D?
There are several C++ scene graph based packages available for OpenGl, like say OSG,

http://w

Why does my php page download images over and over
Can anybody please explain to me why my php page keeps downloading the images and other items every

upload image name with extension using php
hi frds..

<input id="file1" type="file" name="file[]" &a

file downloaded can't be read !!
<?php
$fileName = 'mypic.jpg';
$mimeType = 'image/jpeg';
header('content-dispositio

Typing math
I've added support for typesetting math using LaTeX on the forums.

Example:
Code: [Select]

Could Someone Please Debug This?
I was wondering if someone could debug this script for me. I realize it's not the tidest script (and

Rss feed question
Hi

My blog and my website are different. Am i able to take my rss feed
from my blog and p

Sign up to write
Sign up now if you have flare of writing..
Login   |   Register
Follow Us
Indyaspeak @ Facebook Indyaspeak @ Twitter Indyaspeak @ Pinterest RSS



Play Free Quiz and Win Cash