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>
PHP and Javascript
Hello Everyone,I have a page that needs a javascript code to be written between PHP code but the condition is that javascript code should not be executed. How can I prevent javascript code to be
retrieving images from mysql database using php
So I've been trying to figure out how to store images in a mysql database, and as far as i can tell the images are stored but getting them out seems to be the problem. when i try to go to the page on
Newb advice
Hi all,I'm a flash front end designer and I've taken on a project that needs some back end php.It's not completely greek to me as I write actionscript in flash which is an OO language.However... I
Checking if variable is 0 as opposed to NULL/Empty...
I'm trying to write some code that will retrieve a user's access level from my database and if it doesn't return any values then I want to set the access variable to 2. I'm using... $access_id =
generating random codes
Hi guys n gals,I have a requirement to generate 250,000 unique codes...These codes are for a tracking service and will be stored in the database (table field has a unique index).Now I am working on
Parse Error Help
Hello, I got the parse error "Parse error: syntax error, unexpected ',' in register.php on line 21Heres the code:Code: <body
How to assign a textbox value to PHP variable??
Hi ! Can any one help me out as quickly as possible. As I m new to PHP.Plz tell me how to assign a textbox value to PHP variable on a same PHP page with out POSTING data to other page e.g:$tbVal =
How to add an image/C++ OpenGL?
Hi,
Links not updating
I'm trying to fuel a simple navigation system for a news section. It works fine when it comes to retrieving and displaying data, but if I click on a valid link in the following code, the content and
Grids not displaying decimals, and behaving differently on different PCs?
Hello,
