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 :
"
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 "------> {$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"><?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"> </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>
No comments posted yet
Your Answer:
Login to answer
178 
37 
Other forums
HELP with mysql_real_escape_string
I'm looking to remove apostrophes completely when someone enters lyrics but don't have a clue how to
Referential Integrity problem when inserting into 2 tables at same time
Hello Everyone,
Im relativity new to PHP and MySQL and i have come up against a problem. i h
getting most records by count
Code: [Select]<?php
$connect = mysql_connect("localhost","dam
Problem in OnClientClick and OnClick sync
Hi,Strange and irritating problem:
I have below button declaration in markup of the aspx page:
PHP mail() returns true but doesn't work
First off I apologize if this is a newbie question, and I generally don't like asking questions that
C problem struct and string
Hi guys,
This is my first post and I'm hoping the experts here can help me solve my problem.<
void* and sizeof()
Hi,
Using void* and sizeof is it possible to get the value of the object ?
I understan
Linux socket programming
Where can I find a good introduction to socket programming?
Simple MySQL query...
Hello,
How could I do a mysql query that does this: SELECT * WHERE date/time < 5minutes ag
Website Direction...
I recently used this code to try and make it so the page loads as http://www.domain.com/ when you ty
