Hi David,
Wondered whether you could advise on how I could make this legible so its easier to make out?
LADIES20CELEBRITIES20ACCESSORIES2020JASMINEACCESSORIES
Is their some way in the filters that I could say replace the "20" with a space or dash or something?
Regards
Paul
Hi David,
That works with the cats now more legible, though now that OI have replaced the category in my query, the prodcts do not display?
case "h":
$sql = "SELECT * , MIN( price ) AS minPrice, MAX( price ) AS maxPrice, COUNT( id ) AS numMerchants FROM `".$config_databaseTablePrefix."products` WHERE merchant='Very' AND category LIKE 'LADIES DRESSES LADIESFASHIONBRANDSGOINGOUTDRESSES' GROUP BY name ORDER BY RAND() LIMIT 5"; {link saved}
break;
the only thing thats change from when the items displayed is there are now gaps between LADIES & DRESSES & LADIESFASHIONBRANDSGOINGOUTDRESSES
Any thoughts?
Cheers
paul
Hi Paul,
The easiest thing to do after changing the categories is to go the category index page of the associated Price Tapestry installation (/categories.php or /category/) and check for the exact value as has been imported, and then use that in the SQL - that should be all you need to do.. Check for example whether there is an additional space, for example you require (in your SQL):
LIKE 'LADIES DRESSES LADIESFASHIONBRANDS GOINGOUTDRESSES'If you're not sure email me a link the page with the calling code and the calling code itself (so I can pick up the associated installation) and I'll check it out...
Cheers,
David.
--
PriceTapestry.com
Hi David
I was using the merchantcategories.php file to determine the category {link saved} this displayed, after using the new filter as, "LADIES DRESSES LADIESFASHIONBRANDSGOINGOUTDRESSES".
However, I've followed your suggestion and looked to the /category/ section {link saved} and that same category appears as "LADIES20DRESSES2020LADIESFASHIONBRANDSGOINGOUTDRESSES"
However I have reverted to putting the above category in the query and it still hasn't worked?
I will email you the files
Regards
Paul
Hi Paul,
As it's all ASCII, a Search and Replace on the Category field should do it - search for "20" (without the quotes) and replace with " " (single space character)...
Cheers,
David.
--
PriceTapestry.com