How to show related posts based in category using Sql Server in ASP.Net

Question

HiI have a web page that show a newsI want to show Related Post blow newsHow do I find related post

Mudassar · Accepted Answer

The design is incorrect  design as follows 1 News TableNewsId  Text 2 Category TableCategoryId Text 3 NewsCategory TableNewsId CategoryId In the third table we will insert News and CategoryFor examples News 101 belongs to category 1 and 5 so it will look as followsNews CategoryId101   1101   5

Mudassar · Answer

The below query will get all new related to News 101select NewsId Text fromNews inner join NewsCategory on NewsNewsId  NewsCategoryNewsIdwhere NewsId  101

How to show related posts based in category using Sql Server in ASP.Net

Company

Explore

Follow us

Contact Us