Hi David :)
Well as you may know I am always using Price Tapestry for something else but price comparison :)
Things are like this, I dont need category so I changed code a bit.
$priceWhere .= " AND categoryid = '".database_safe($categoryFilter)."' ";
$priceWhere .= " AND category = '".database_safe($categoryFilter)."' ";
Changed category filter, because I am using it together with $q I did it like this and hope I did it right :)
$categoryFilter = (isset($_GET["tag"])?tapestry_normalise($_GET["tag"],":\.\/"):"");
Next I did this:
$qarray = $q.' '.$categoryFilter;
$parts = explode(":",$qarray);
Hope I did it right, because have no idea what am I doing but seems its working fine lol
Now, I am using Category Mapping to add words there, in my case they will work as tags.
Final question is how to join categories and products tables? Want to use it in searchfilters.php
I want to take name from categories table and search description in products table
with that category name and get count, and order by count desc.
CategoryName (30) - 30 is number of how many products contain word CategoryName in their description.
Hope you understood me lol :D
Thanks David :)