X-Cart forums

[harold5370]

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

$substring_condition = ($substring==""?"":"and ($sql_tbl[products].product like '%$substring%' or $sql_tbl[products].descr like '%$substring%') ");

to this

$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?

[harold5370]

Doesn't anyone have any idea here?

[walteis]

Where did you make the change? I did a similar change to customer/search.php and it works fine.

Walt

[rodneyw]

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?

$substring_query = "AND (($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%'  ....

and

$substring_query = "AND ($sql_tbl[products].param00 like '%$substring%' or $sql_tbl[products].product like '%$substring%' OR ....

[groovico]

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.

[rodneyw]