autosuggest + mysql

[guif]

I would like to make a simple autosuggest but i don't understand why my code is not running.

Help me please!

 

here is the code:

 

<?php

require_once('db.php');

include('classes/stem.php');

include('classes/cleaner.php');

 

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

 

$string = $_POST['search'];

 

$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 pkey from jiraissue where project = '10040' and pkey like '%".$val."%'";

 

if($total>0){

echo '<ul>';

while ( $row = mysql_fetch_assoc ( $query ) ){

echo '<li>'."\n";

echo $row['pkey'];

echo '</li>';

}

echo '</ul>';

}

?>