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>
Text to picture Generator
Hello, i have found this script and it works really good^^ But i have one problem, i would like to change the font and font size. Is there anyone here that know what code i should edit/paste in
Getting PHP to ammended the selected in option field
Hey Guysthanks for everyones help so far. This site and its users are oozing awesomness.I am busy with a php script for editing users, of which 1 field is the TITLE of the person (mrs, miss, ms) and
Code doesn't print what i wanted it too. Please help!
Hi there,I wrote this code to mae it so that in the form before it that the user said their username and then on this page it matches up the username with the username on the database and then uses
problem with php mysql query
Hi guy's...I'm totally lost here..because don't have any idea how to make a query for grab record using BETWEEN startdate and enddate since existing record are stored using this format
TemplatePower & AJAX
Hi all,I'm currently implementing some AJAX features in my PHP-framework (which is based on TemplatePower) and I have encountered a problem:I have a block which holds a message-div. This block is
Strange array issue, never happened before.
mysql_fetch_array returns 1 array per call. Generally that's why it is inserted into a while statement. I generally loop through them in a while statement and put them all in a master array so I
Parse error: syntax error, unexpected $end in
hello,i receive the error :Parse error: syntax error, unexpected $end in C:\xampp\xampp\htdocs\helpdesk\users.php on line 372i looked allover the code but i can't find the curly bracket missing or
Mastering Regular Expressions, Third Edition, is available.
The Third Edition of Mastering Regular Expressions is available.QuoteThis third edition is 58 pages longer than the second edition, and now reaches 542 pages in length. The main changes from the
query based on 2 conditions
I want to select if the doc_type is either s OR f but this doesn't work:Code: [Select]$query2 = "SELECT * FROM members WHERE doc_type='s' && doc_type= 'f' ORDER BY
captcha error
I have been trying to implement a captcha in php...here is the code..Code: (php) [Select]<?php// Set the content-typeheader('Content-type: image/png');// Create the image$im =
