Hi !Topics of my forum link to a page of my annuary thanks to a MATCH request that work fine :SELECT annuary_cat_id, annuary_cat_name FROM annuary_categories WHERE MATCH (annuary_cat_name,annuary_cat_text) AGAINST ("$forum_topic_title")Inversely, I want that page of the annuary can list the forum topics which point towards that page of the annuary. But I have problems to find the good request. I tried :SELECT topic_id, topic_title, annuary_cat_id, annuary_cat_name, annuary_cat_texte FROM forum_topics, annuary_categories WHERE annuary_cat_id = "105" AND topic_id=(SELECT topic_id FROM forum_topics WHERE MATCH (annuary_cat_name,annuary_cat_texte) AGAINST (topic_title) LIMIT 0,1)
phpmyadmin (MySQL version 5.0.51a) says : "Incorrect arguments to AGAINST"How can I do ?
embedded MATCH request
Posted - 2010-09-21 : 09:34:27
