Results 1 to 2 of 2

SimpleSuggest - Ajax Search Suggestion

This is a discussion on SimpleSuggest - Ajax Search Suggestion within the New osCommerce Contributions forums, part of the osCommerce 2.2 Forums category; I fixed the language decoding of special language chars, I have tried it with a polish product name and it ...

      
  1. #1
    osCMax Developer

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    19,501
    Rep Power
    567


    Post SimpleSuggest - Ajax Search Suggestion

    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...
    Michael Sasek
    osCMax Developer


    osCmax installation service - Have our professionals install osCmax on your server - same day service!
    osCmax 2.0 User Manual - the must have beginners guide to osCmax v2.0

    Stay Up To Date with everything osCMax:
    Free osCMax Newsletters - Security notices, New Releases, osCMax News
    osCMax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  2. #2
    Lurker
    Join Date
    Jan 2010
    Posts
    1
    Rep Power
    0


    Default Re: SimpleSuggest - Ajax Search Suggestion

    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.

    PHP Code:
       $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

Similar Threads

  1. SimpleSuggest - Ajax Search Suggestion
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-16-2009, 11:50 AM
  2. SimpleSuggest - Ajax Search Suggestion
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-16-2009, 05:51 AM
  3. SimpleSuggest - Ajax Search Suggestion
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 11-15-2009, 11:00 AM
  4. AJAX Search Suggest
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-03-2009, 03:00 AM
  5. Ajax Search Suggest
    By michael_s in forum New osCommerce Contributions
    Replies: 0
    Last Post: 02-02-2009, 02:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •