X-Cart forums

[zingodingo]

Originally Posted by Jon

In include/search.php

FIND:

                if($products[$k]['descr'] == strip_tags($products[$k]['descr']))
                    $products[$k]['descr'] = str_replace("\n","
",$products[$k]['descr']);
                if($products[$k]['fulldescr'] == strip_tags($products[$k]['fulldescr']))
                    $products[$k]['fulldescr'] = str_replace("\n","
",$products[$k]['fulldescr']);

After put:

            $tempid = $products[$k]['productid'];
            $maxprice = func_query_first("SELECT price FROM $sql_tbl[pricing] WHERE quantity='1' AND productid='$tempid' AND membership=''");
            if ($maxprice[price] > 0) { $products[$k]['maxprice'] = $maxprice[price]; }
            else { $products[$k]['maxprice'] = $products[$k]['price']; }

Then use $products[whatever].maxprice in your templates.

I can not make it work. I have following error. please help.
NVALID SQL: 1054 : Unknown column 'membership' in 'where clause'
SQL QUERY FAILURE:SELECT price FROM xcart_pricing WHERE quantity='1' AND productid='240' AND membership=''