lexijade

Member
  • Content count

    18
  • Joined

  • Last visited

Community Reputation

0 Neutral

About lexijade

Profile Information

  • Gender
    Female
  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. Remove cents from price

    Oh duh. Totally didn't even see that in the admin. That's exactly what I was looking for, thanks!
  3. Is there a way to format it so that the price just shows as whole dollars with no cents? Nothing we sell has cents, so I would like to hide those and have it just be the dollar amount.
  4. 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!!
  5. 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
  6. 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.
  7. fuzzy search

    Any idea which file I'd use?
  8. 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.