trying to install roScripts Ajax Autosuggest

[[-_-]]

Ok Im using Mysql 5.0

Im trying to install roScripts Ajax Autosuggest but Im running into some problems. I am an elite HTML coder but Im clueless when it comes to real code.

 

I made the database, filled in the database info in the db.php file, ran the sql.sql query succesfully. went to the index typed in a query and nothing. 

 

Am I doing something wrong? How would I make a list of search suggestions? I think Im supposed to do something in Mysql but I have no idea what. :-\

 

Here is a link to the place where I got the code http://www.roscripts.com/Ajax_autosuggest_autocomplete_from_database-154.html

 

And here is where Im fiddling around with it http://www.plentyoftorrents.com/autosuggest/index.php

 

Thanks.

 

[rhodesa]

Well, the AJAX looks to be working fine, but the response from http://www.plentyoftorrents.com/autosuggest/response.php is empty every time. Can we see your code for response.php?

[[-_-]]

Yup sure, heres the response.php

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

 

 

[[-_-]]

I also just tried changing the $main_url = 'http://www.roscripts.com/'; to my url http://www.plentyoftorrents.com/autosuggest/ nothing then http://www.plentyoftorrents.com/autosuggest/index.php and still nothing.