* saralk waits for someone to point out a really obvious mistake

code:

---

$terms = array();
$terms = explode(" ", $search);

foreach ($terms as $value) {

    $text = str_replace($value, "<span style='background-color:#FFFF00'>$value</span>", $row["Text"]);

}

echo $text;

---

use $text .= str_replace crap here;

nope, that doesn't work it just adds $text again and the next time round it highlights the next word in the array.

whats $row[Text]?

show me the whole code

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";
?>

---

Everytime you run the foreach loop, you are overwriting the value of $text so that when it is echoed out only the last value run is shown.

Try changing it an array, then use print_r to print the array?

I fixed it now, and it was something really simple

I just moved $text = $row["Text"]; outside the foreach section