X-Cart forums

[tcatrainer]

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

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

$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

[B00MER]

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

[tcatrainer]

how can I print to the screen?

[B00MER]

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

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

hth.