Loading

in forum i wish to know how to count the number of replies and views

krithika muthukrishnan

16y2.3k.NET

hai,
here i upload 1 text file that is i designed 2 table 1 for posted questions and other for collecting the replies,i dont know how to count the replies in asp.net and display it

Thank u,

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Suthish Nair16y ago
If this query got resolved then please Accept the post that helped you as Answer.

So other members can easily find the answers.
0
Suthish Nair16y ago
you need to use sql joins, combine both table with PK/FK and retrive the counts.

for ex:
```
select Question, Count(Replies)
from Q1 q, R1 r
where q.qid = r.qid
group by Question
```
0