How to select Related news from database ? RSS

• • Reply
  

  linux_nd

  Member

  92 Points

  42 Posts

  How to select Related news from database ?

  Apr 05, 2012 06:59 AM|LINK

  Hi everyone !

  I'm coding news website but I don't know select related news from table to display. Please help me

  My table tbl_News(ID, Title, Sort, Content, CreatedBy, CreatedDate, View, Tag) and in [Tag] I insert string key related

  Không học không biết, học rồi sẽ biết
• • Reply
  

  Shankar_ss

  Participant

  1270 Points

  279 Posts

  Re: How to select Related news from database ?

  Apr 05, 2012 12:57 PM|LINK

  select * from tbl_news where tag like '%your keywords here%'

  This will help you get all items that match in tag.

  Hope this helps.

  Please mark as answered if this answer helped you.
  
  Shankar
  • Marked as answer by decker dong - msft on Apr 11, 2012 02:05 AM
• • Reply
  

  linux_nd

  Member

  92 Points

  42 Posts

  Re: How to select Related news from database ?

  Apr 05, 2012 10:57 PM|LINK

  Thanks Shankar_ss support. I trying ...

  Không học không biết, học rồi sẽ biết
• • Reply
  

  Decker Dong ...

  All-Star

  118619 Points

  18779 Posts

  Re: How to select Related news from database ?

  Apr 07, 2012 01:06 AM|LINK

  linux_nd

  but I don't know select related news from table to display.

  What do you mean by "related news"？