mysql search problem

[music_man]

Hi

I am trying to get this search to work. I would like it so that it can display the search results so that it displays a snippet of the result. Also it only searches "content".

<?php $p="home"; require("top.php");
?>
<div id="content">
  <?php require("dbconnect.php"); dbconnect();

  $search = $_GET["search"];  

  if(isset($search)) {

  echo "<p class=\"large_heading\">
  Search -> $search</p>";
                echo $string;
        $result = mysql_query("SELECT * FROM blog WHERE content LIKE '%$search%'"); // WHERE content, title, date ?

    if (mysql_num_rows($result) > 0) {

    echo "<ol>";


    while($row = mysql_fetch_array($result))
    {

// from http://www.invalidresponse.com/module-Forum-viewtopic-topic-20.html

    $string = $row[2];

    $message_parts = explode(' ',$string); // problem

    foreach($message_parts as $k=>$part){

    $part_length = strlen($part);

    if($part_length > 15){

    $part = substr($part,0,13).'..'; 

    }

    $new_part[$k] = $part;

    }
    $string = implode(' ',$new_part);

    echo "<li><b>" . $row[1] . "</b>&nbsp;::&nbsp;" . $row[3] . "<br /><br />". $string ."</li>";

    }
    }

    else {

    echo "<p class=\"notice\">Sorry there were no results for <b>" . $search . "</b></p>";

    }

    dbdisconnect();
    }
    else {

    echo '<p class="large_heading">Search</p>';

    echo "<p class=\"notice\">Please submit a search first</p>";

    }
  ?>
</div>
<?php require("bottom.php");
?>

[esukf]

$message_parts = explode(' ',$string); // problem

    foreach($message_parts as $k=>$part){

    $part_length = strlen($part);

    if($part_length > 15){

    $part = substr($part,0,13).'..';

    }

    $new_part[$k] = $part;

    }
    $string = implode(' ',$new_part);

This code limits only a single word greater than 15 characters in a string and not the whole string so if none of the words is over 15 characters it won't do much.

To return only a certain number of characters in a string you just need to use

 $string_lenght = 50;
$new_string = substr($string,0,$string_lenght);

[music_man]

Excellent thanks!

I have"

        $pre_content = $row[2];
        $string_length = 100;
        $count = strlen($pre_content);
        if  ($count >= 100) {
        $content_almost = trim(substr($pre_content,0,$string_length)); 
        $content_there = $content_almost . "...";
        }
        else {
        $content_there = $pre_content;
        }

Is there a more efficient way of doing that? lol.

Any ideas on the search parameters? I would like it to encompass the titles.