autosuggest + mysql

guif's Avatar
Go4Expert Member
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 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 ) -) );

if ( 
strlen $new_string ) > ):

$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>';
}
?>

Last edited by shabbir; 17Sep2008 at 18:54.. Reason: Code block
codestorm's Avatar, Join Date: May 2008
Go4Expert Member
Are you getting any specific errors??
guif's Avatar
Go4Expert Member
I give this code in the web, and i change some code. But, i think that's some parts are not correct.
For example, in the Select, at the final:, what it's $val???
and the <li> is correct???

i don't see and specific error because I don't see nothing