Estoy intentando leer una columna de mi BBDD en MySQL mediante el tipico Autosuggest.
No me muestra nada... alguien tiene idea de que me puede suceder?
<?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>';
}
?>