Hey everybody,

I have another little problem and hope you can help me to solve this.
I'd like to compare the tags setted in an article with the item title of another article. E.g. article1 has tag firm1, this article should show up under the article with the title "firm1". In my override it works - except there is a dash in the item title. K2 strips out the dash in the tags. Right now I'm using a mySQL-query and I don't know how I can strip the dash in the item title out. My code looks as follows:As you can see I get the id of the tag and compare the name with the item title --- but the dashes...?! :(
Any suggestions?

Kind regards
Matthew.

Hello,
I am sorry but I do not understand where this dash appears ? Is it in the ca.`title` at your mysql query ?

Correct. The firm name (ca.`title`) is e.g. "We - from outer space". In the tags the dash is stripped, so the firm name (c.`name`) is "We from outer space". Because of this the query does not recognize that it is the same firm name, without dash. So no array is generated.
Do you know what I mean?

You can use the mysql REPLACE function to replace the dashes

dev.mysql.com/doc/refman/5.7/en/string-functions.html#function_replace

Below I provide an example with your database query

YES YES YES!!! Thank you so much. I tried the REPLACE-function, but I did not really know how to use this. *happy* :)