BIAMNEIMAa
New Member
i have two mysql tables which are linked together and i need to show my category list table_stories\[code\]sid || title || time || hometext || associated1 || test || 2010-07-19 || text---- || 8-14-\[/code\]table_topics\[code\]topicid || topicname || slug1 || car || car 4 || wall || wall 8 || benz || benz 14 || ford || ford \[/code\]now if i use this query to fetch story list :\[code\] LEFT JOIN table_topics AS nto ON (CONCAT(' ',COALESCE(ns.associated,'-'),'-') LIKE CONCAT('%',nto.topicid,'-%'))\[/code\]then output would show stories with topic id : 8 , 4 , 14 you see that it counts topic id 4 as similar as 14 please concider that i cant change mysql table structure and i should find a work around for this problem