i have a similar question with this question:. But using SQL server not Mysql. Im now using PHP and SQL SERVER 2005.
My question is: How to find related post using PHP and SQL server?
sorry no code, i even cant start writing code because i still dont have idea how to do this. maybe start something like this
<?php
$title = "Stackoverflow is one of the best website in the word";
$exp = explode(' ', $title);
$where = '';
foreach($exp as $word){
$where .= "title LIKE '%$word%' OR body LIKE '%$word%' ";
}
$query = "SELECT TOP 5 title FROM tbl_article WHERE $where";
?>
thanks in advance