X-Cart forums - search.php which one to modify?

X-Cart forums (https://forum.x-cart.com/index.php)

- Changing design (https://forum.x-cart.com/forumdisplay.php?f=51)

- - search.php which one to modify? (https://forum.x-cart.com/showthread.php?t=1072)

search.php which one to modify?

I was looking to modify the search sql to search for another field the partnumber

Quote:

$search_query = "(
$sql_tbl[products].productcode like '%$substring%'
or
$sql_tbl[products].product like '%$substring%'
or
$sql_tbl[products].descr like '%$substring%')

and
$sql_tbl[categories].category like '$search_category%'
and
$sql_tbl[products].forsale='Y' $price_condition ".$sort_by_price;

All I should really have to do is add:

Quote:

$sql_tbl[products].productcode like '%$substring%'
or

i changed it in <
xcart dir>/admin/search.php
xcart dir>/customer/search.php
xcart dir>/provider/search.php
but it seems to have no effect when you actually performa a search.
It appears it should be calling
http://www.aeroaccess.com/xcart/customer/search.php

Have you tried printing the entire query to the screen and copy/pasting it into phpMyAdmin to see what kind of results you get?

how can I print to the screen?

$sql = (long query string)
print $sql;

basically rebuild the sql statement into a var and print the var to the screen.

hth. :wink: