• Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Profile Information

  • Gender
  1. I want to replace the text that says $0 with Call for Price. I have done this before, but when I updated it reverted, and I can't for the life of me find where I go to change this! Please help.
  2. fuzzy search

    I am using V6 with an old skin apparently lol. Thanks for the code. I put that in instead of what I had before and it works perfect! This has been driving me insane, but now it's fixed. Thank you so much for all of your help!!
  3. fuzzy search

    With this as my code nothing shows up on the page- it's totally broken, but there aren't any errors in the debug. $noKeys = count($searchArray); $regexp = ''; $rlike = ' AND ( '; for ($i=0; $i<$noKeys; ++$i) { $ucSearchTerm = strtoupper($searchArray[$i]); if ( ($ucSearchTerm != 'AND') && ($ucSearchTerm != 'OR') && (strlen($ucSearchTerm) > 0) ) { $searchArray[$i] = str_replace(array('%','_'), array('%','_'), $searchArray[$i]); $regexp = '%'.$searchArray[$i].'%'; } else { $rlike .= " ".$ucSearchTerm." "; continue; } $rlike .= "(I.name LIKE '".$regexp."' OR I.seo_meta_keywords LIKE '".$regexp."' OR I.product_code LIKE '".$regexp."') AND "; } $rlike = substr($rlike, 0, strlen($rlike)-5); $rlike .= " )"; } $q2 = "SELECT I.* FROM ".$GLOBALS['config']->get('config', 'dbprefix')."CubeCart_inventory AS I LEFT JOIN (SELECT product_id, MAX(price) as price
  4. fuzzy search

    Tried this again and it worked. Seems to do exactly what is required. Thanks bsmither. I must be doing something wrong because that doesn't work for me :/ [Notice] /home/content/88/5118188/html/ltcube/classes/catalogue.class.php:1530 - Undefined variable: order [Notice] /home/content/88/5118188/html/ltcube/classes/catalogue.class.php:1598 - Undefined variable: noKeys I am getting these errors, not sure if that helps.
  5. fuzzy search

    Any idea which file I'd use?
  6. fuzzy search

    It doesn't seem to be working for me. I have tried all of the different codes you suggested, but when I search for freeze instead of freezer nothing shows up.