Search Results

15 posts by 4 authors in: Forums > CMS Builder
Last Post: June 18, 2013   (RSS)

By dccreatives - June 18, 2013

Here are the files that I modified. The url search works nicely, but then the left search does not work.

By dccreatives - June 18, 2013

You can see the results of those files on this page:

http://www.axislighting.com/CMS_french/search_products2.php?mounting_french=Encastr%C3%A9

What I noticed is that when we change allow search to true, the left search does not work.

By Jason - June 18, 2013

Hi,

Since you are building your WHERE clause yourself, you don't need to enable allowSearch or use _match.  Is mounting_french a mulit value field?  If so, you'll need to add tab (\t) characters to your WHERE clause.  Try using this page:'

http://www.axislighting.com/CMS_french/search_products.php

and change your where clause like this:

if((@$_REQUEST['mounting_french'] != "undefined") && (@$_REQUEST['mounting_french']) ) {
  $where .= " AND mounting_french LIKE '%\t" . mysql_real_escape_string($_REQUEST['mounting_french']) . "\t%' ";
}

Hope this helps

---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com

Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/

By dccreatives - June 18, 2013

PERFECT!!!

Thanks loads!