0) {
// output data of each row
while($row = mysqli_fetch_assoc($result)) {
//echo "id: " . $row["id"]. " - Name: " . $row["file_name"]. " " . $row["uploaded_on"]. "
";
$keywords = $row["keywords"];
$this_caption = $row["caption"];
////////
$daysLeft = 0;
$fromDate = $row["expiredate"];
$curDate = date('Y-m-d');
$daysLeft = abs(strtotime($curDate) - strtotime($fromDate));
$days = $daysLeft/(60 * 60 * 24).' days';
////////////////////////////////
$today_date = date('Y-m-d');
//echo '
';
$sql_keywords = "SELECT * FROM `blog` WHERE MATCH (caption) AGAINST ('$this_caption') ORDER by id DESC LIMIT 5";
//$query = mysqli_"SELECT * FROM `blog` WHERE MATCH (caption) AGAINST ('$keyword')");
$result_keywords = mysqli_query($conn, $sql_keywords);
if (mysqli_num_rows($result_keywords) > 0) {
// output data of each row
//echo '
Related Stories ';
while($row_keywords = mysqli_fetch_assoc($result_keywords)) {
//echo "id: " . $row["id"]. " - Name: " . $row["file_name"]. " " . $row["uploaded_on"]. "
";
$related_ref = $row_keywords["ref"];
$related_expiredate = $row_keywords["expiredate"];
if ($related_expiredate > $curDate) {
if ($related_ref <> $this_ref) {
echo '
';
echo'READ ALSO → '. $row_keywords["caption"].'
';
$story_video_1 = $row_keywords['video'];
if(isset($story_video_1)) { ///
echo '
Video';
}///
}//////////
}
}
} else {
//echo "No related story found";
}
//mysqli_close($conn);
////////////////////////////////
}
} else {
//echo "0 results";
}
?>
Attached Documents
0) { // ?>
Stories from the same author
|
|
$this_caption) { //// ?>
|
$this_caption) { //// ?>
Video
.
|
All Headlines
Categories
Return
Most Read Stories
Recent Stories
All Headlines
Categories
Return