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