SimpleSuggest - Ajax Search Suggestion

[michael_s]

I fixed the language decoding of special language chars, I have tried it with a polish product name and it worked.

I have posted all details about the AJAX search suggestion and actual problems on:

http://oscommerce-simplesuggest.blogspot.com/

This contains only the changed searchSuggest.php

More...

[mdjl]

Hi All, Not sure if this is in the right place, but here goes,

I'm trying to mod the searchsuggest contrib, but am stuck with the following.

    $search_suggest_query_raw = "select pd.products_name, 
p.products_image, p.products_id from " . TABLE_PRODUCTS_DESCRIPTION . 
" pd left join " . TABLE_PRODUCTS . " p on pd.products_id = p.products_id 
WHERE p.products_status = '1' and p.products_id = pd.products_id and 
pd.language_id = '" . (int)$languages_id . "' and pd.products_name like '%" 
. tep_db_prepare_input($search) . "%'";



$search_suggest_split = new splitPageResults($_GET['page'], 
MAX_DISPLAY_SEARCH_RESULTS,$search_suggest_query_numrows,
$search_suggest_query_raw);


       $search_suggest_query = tep_db_query($search_suggest_query_raw); 
  

I'm trying to put a split the pages up save limiting the number of returns from the database.
Now to me that looks fine, but for the life of me cant see why its generating a MYSQL error..

Any ideas, advice, much appreciated.

Thanks