Hello everyone, I'm new to this forum and to asp too.
I have a problem and i thought someone here could help me.
I have two tables. tblComments(id, text, newsid) and tblNews(id, text). Thats One To Many
I want to count how much comments some news have but the problem is that I display more topics/news on one page.
I was thinking about SELECT FROM WHERE but i can't think of any where statement which fits.
I tried assigning the id value from tblNews to a variable but it doesnt work when i use it with WHERE newsid=thevariable... ...
Go to the complete details ...