Shoutbox

code:

---

<?php

include "sql.php";
include "header.php";
$sql = "SELECT * FROM posts WHERE MATCH (Subject,Text) AGAINST('".$search."')";
$rs=mysql_query($sql,$conn);
mysql_error($conn);
echo "<div id='blogcontainer'>";
echo "<div id='blogtitle'>Search Results</div>";
echo "<div id='blogcontent'>You searched for <b>".$search."</b>, these words have been highlighted in the results below</div>";


while ($row = mysql_fetch_array($rs)) {
$terms = array();
$terms = explode(" ", $search);
foreach ($terms as $value) {
$text = $row["Text"];
$text = str_replace($value, "<span style='background-color: #FFFF00'>$value</span>", $text);
}
echo "<div id='blogtitle'>".$row["Subject"]."</div>";
echo "<span class='blogcontent'>";
echo $text;
echo "</span>";
echo "<div id='blogfoot'>Posted by ".$row["User"]." on ".$row["time"]." | <a href='view.php?newsid=".$row["newsid"]."'>Comment</a></div>";

}

echo "</div>";
include "footer.php";
?>

---