|
Problems with Searching Extra Fields
I am trying to extend the functionality of the search by setting param00 to a lsit of keywords which I can search on.. I have modified the following line
Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%') ");to this Code:
$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%' or $sql_tbl[products].param00 like '%$substring%') ");but I still can not seem to return any results to match the text in the keywords (param00) field. Does anyone have experience or suggestions with this? |
Doesn't anyone have any idea here? 8O
|
Where did you make the change? I did a similar change to customer/search.php and it works fine.
Walt |
ok, after searching the forums and trying to figure this out I can't not get the customer/search.php to pick up on the extra field (param00)
There seems to be only 2 places where it makes sense to add the conditions for param00 and that is in the $substring_query. Anything wrong with my code here? Code:
$substring_query = "AND (($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%' ....and Code:
$substring_query = "AND ($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%' OR .... |
From our experience there is bugs or strange logic in the way x-cart deals with extrafields. You are not guaranteed slot param00 if you have deleted/removed/edited your extra fields any anyway.
They appear to shift around when one is removed. :roll: |
:cry:
|
| All times are GMT -8. The time now is 02:19 AM. |
Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.