Incrementing The number of posts

3 New Member

Hii.

Im just writng a script for making a discussion forum...ALl things are working..

but i want in the first page to dispaly the number of comments on each topic.I use the mysql query SELECT COUNT but it dosnt displat anything..

sometimes i get a messgae like ResourceID#6..

any body please help me...

Thanks in advance..

The code is listed below..

Expand|Select|Wrap|Line Numbers

 
<?php

include("connectivity.php");

$cnt=mysql_query("select count(iCommentId) from comments where iTopicId='33'");

while($row=mysql_fetch_array($cnt)) {
 
echo("Count: - ".$row["iCommentId"]."<br>");

}
 
$qry=mysql_query("select * from topic"); 

$hid=$_REQUEST['hid'];

//$start=0;
 
//echo "$cnt";

?>
 
<html>

<head>
 
<title>Discussion form</title>

</head>

<body>
 
<h3 align="center">Discussion Forum Using PHP</h3></td><br>

<form name="frm">

<table align="center" border="2" bgcolor="#00FFFF">

<tr><td colspan="11" align="right"><a href="addtopic.php">Add New Topic</a></td></tr>

<tr><td colspan="7" align="center">
 
<tr><td width="30">Si</td>

<td>Topic</td>

<td>Comments</td>

<td>Posted BY</td>

<td>E-mailid</td>

<td>Date</td>
 
</tr>
 
<?php

$si=1;

while($obj= mysql_fetch_object($qry))

{
 
$topc=$obj->vTopic;
 
$dat=$obj->ddate;

$newdate=explode("-",$dat);

$ddate="$newdate[0]-$newdate[1]-$newdate[2]";

echo
 
    "<tr>

        <td>$si</td>

        <td><a href=\"viewcomments.php?hid=$obj->iTopicId\" style=\"text-decoration:none\">$topc          </a></td>

        <td>Comets</td>

        <td>$obj->cPostedBy</td>

        <td>$obj->cemail</td>

        <td>$ddate</td>

    </tr>";
 
    $si++;
 
}

?>
 
</td>

</tr>
 
</table>

</form>

</body>

</html>

[Please use CODE tags when posting source code. Thanks! --pbmods]

Jun 12 '07 #1

Subscribe Reply

1262

ronnil

134

Recognized Expert New Member

you can use mysql_num_rows($qry) to count the number of rows retrieved by your sql statement

Jun 12 '07 #2

jenishkottaram

New Member

Expand|Select|Wrap|Line Numbers

 
<?php

include("connectivity.php");
 
$qry=mysql_query("select * from topic"); 

$hid=$_REQUEST['hid'];
 
$cnt=mysql_query("select count(iCommentId) from comments where TopicId='33'");

$mycount=mysql_num_rows($cnt);

echo "$mycount";
 
?>

dude i try dis also..but no change at all...

ill say the problem clearly..ive 2 tables one is for entering the topics and the other is for commets.On clicking the topics d link ll pass 2 d commenst..now i wants in the first page itself near the topic we need to display the no: of comments on each topic..

Jun 12 '07 #3

ronnil

134

Recognized Expert New Member

remove the count() in your select statement :)

you can also try "select count(iCommentId) as num_comments from comments where TopicId=33"

then you can fetch the result with by referring to num comments

$row_obj->num_comments

or if retrieving arrays

$row_arr['num_comments']

Jun 12 '07 #4

jenishkottaram

New Member

dude ..thanx.....

itz working...

and the code is..

$cnt=mysql_query("select * from comments where iTopicId='33'");
$mycount=mysql_num_rows($cnt);

echo $mycount;

Jun 12 '07 #5

Similar topics

2559

Incrementing Number in Repeat Region - Help!

by: Tom | last post by:

Anyone help on this? PHP/MySQL I have a repeat region displaying records from orders in a CSV format: CalJoe33,18,08/23/2004,FED EX,PREPAID,WEBSITE,CA,Book,25.95,??? CalJoe33,18,08/23/2004,FED...

PHP

2873

looping/incrementing problem...

by: Mothra | last post by:

Here's what I'm trying to do (kill off old Unix logins): --------------------- $i=0; while (<$who>) { chomp($_); my @line = split(/\s+/, $_); # Split it into an array next unless ($line...

Perl

420

RegExp: incrementing digit in replacement expressions

by: brian | last post by:

Hi, before coming to .NET, I utilized regular expressions mostly in JScript / JavaScript and also in my favorite text editor: TextPad (www.textpad.com) I don't know about JScript/JavaScript, but...

.NET Framework

2545

incrementing recordID without using AutoCount

by: Payson Books | last post by:

Where can I find some info on grabbing the recordID of the last record, incrementing it by one, and using the new number in a new record.

Microsoft Access / VBA

4730

incrementing void *

by: subramanian100in | last post by:

I saw this question from www.brainbench.com void *ptr; myStruct myArray; ptr = myArray; Which of the following is the correct way to increment the variable "ptr"? Choice 1 ptr = ptr +...

C / C++

6509

Incrementing Letters

by: Lilbrat | last post by:

Im not finding anything similar in the Posts so correct me if Im wrong... Im real new to programing in Access (Been a while since I programed in anything). The question I have is.. How do you...

Microsoft Access / VBA

1522

Help with Incrementing

by: TXpugslave | last post by:

And here it is. I'm just, JUST learning how to use perl, and how to do any sort of programming in general. I'm trying to self-teach and have read a book on C programming and wanted to try PERL. I'm...

Perl

3493

incrementing number in a subform

by: asandiego | last post by:

Hey guys, this is my first post here but have been checking this site a lot for anything I need. I hope someone can lead me to what I should do or just an idea to what can be done. What I'm...

Microsoft Access / VBA

2582

How to stop incrementing the DLL version number?

by: John | last post by:

I have written a VB.NET DLL that is called by a third party program. If I make any changes in the DLL and then try to replace my DLL file the third party program will abort, saying that the DLL...

Visual Basic .NET

7205

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7093

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7353

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

7011

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7468

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

4689

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

3180

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

3170

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

401

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

General