I'm tring to add a few options to the searching box that is provided. I have already made it so it will search some of the params that I have added to the product table, but this only works for searches done with the provided search box. I tried adding a drop down which would be incorporated into the seach but I'm getting this error:
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/mysite/xcart/config.php on line 293
This is how I modified the code on search.php:
Code:
$search_query = "(products.product like '%$substring%' or products.descr like '%$substring%' or products.productcode like '%$substring%' or products.param05 like '%$substring%' or products.fulldesc like '%$substring%') and categories.category like '$search_category%' and products.forsale='Y' and products.param04 = '$selGenre' group by products.product";
I added the "and products.param04 = '$selGenre' " part.
I am planning on adding an advanced search page but this was a first temp step. Any thoughts would be appriciated.
thanks
Ryan