PHP - Moved: Help With Autosuggest Code

Hello,

I am trying to implement some code I found and downloaded he
http://www.roscripts.com/Ajax_autosuggest_autocomplete_from_database-154.html

When I try and run this I get no search results back when searching? I have entered data in the database and all connections seem good. Several people in the comments say they have problems, but no solution.

Any one that can find the fault here?

- THANKS


<?php
require_once('db.php');
include('classes/stem.php');
include('classes/cleaner.php');

if( !empty ( $_POST['search'] ) ):

$string = $_POST['search'];
$main_url = 'http://www.roscripts.com/';

$stemmer = new Stemmer;
$stemmed_string = $stemmer->stem ( $string );

$clean_string = new jSearchString();
$stemmed_string = $clean_string->parseString ( $stemmed_string );

$new_string = '';
foreach ( array_unique ( split ( " ",$stemmed_string ) ) as $array => $value )
{
if(strlen($value) >= 3)
{
$new_string .= ''.$value.' ';
}
}

$new_string = substr ( $new_string,0, ( strLen ( $new_string ) -1 ) );

if ( strlen ( $new_string ) > 3 ):

$split_stemmed = split ( " ",$new_string );
        
        mysql_select_db($database); 
$sql = "SELECT DISTINCT COUNT(*) as occurences, title, subtitle FROM articles WHERE (";
             
while ( list ( $key,$val ) = each ( $split_stemmed ) )
{
              if( $val!='' && strlen ( $val ) > 0 )
              {
               $sql .= "((title LIKE '%".$val."%' OR subtitle LIKE '%".$val."%' OR content LIKE '%".$val."%')) OR";
              }
}

$sql=substr ( $sql,0, ( strLen ( $sql )-3 ) );//this will eat the last OR
$sql .= ") GROUP BY title ORDER BY occurences DESC LIMIT 10";

$query = mysql_query($sql) or die ( mysql_error () );
$row_sql = mysql_fetch_assoc ( $query );
$total = mysql_num_rows ( $query );
 
if($total>0):

        echo ' <div class="entry">'."\n";
echo ' <ul>'."\n";
while ( $row = mysql_fetch_assoc ( $query ) ) 
{
echo ' <li>'."\n";
echo ' <a href="'.$main_url.'articles/show/'.$row['id'].'">'.$row['title'].''."\n";
echo ' <em>'.$row['subtitle'].'</em>'."\n";
echo ' <span>Added on 2007-06-03 by roScripts</span></a>'."\n";
echo ' </li>'."\n";
}

echo ' </ul>'."\n";
echo ' </div>'."\n";
endif;
endif;
endif;
?>


The code can be found in attached zip file.

This topic has been moved to Other Libraries and Frameworks.

http://www.phpfreaks.com/forums/index.php?topic=334386.0

This topic has been moved to Third Party PHP Scripts.

http://www.phpfreaks.com/forums/index.php?topic=349890.0

This topic has been moved to PHP Applications.

http://www.phpfreaks.com/forums/index.php?topic=351710.0

This topic has been moved to HTML Help.

http://www.phpfreaks.com/forums/index.php?topic=352862.0