cartpauj Posted April 21, 2010 Share Posted April 21, 2010 I am helping to develop a php forum software but some of our beta testers are having problems with the following mySQL query returning empty results. I setup two identical sites on my WAMP test server and the query works on one test site but not the other...I can't figure out why, if someone could help me figure this out it would be great: SELECT forum_threads.parent_id as pt, forum_posts.id, text, forum_posts.subject, forum_posts.parent_id, forum_posts.`date`, MATCH (text) AGAINST ('something') AS score FROM forum_posts inner join forum_threads on forum_posts.parent_id = forum_threads.id WHERE forum_threads.parent_id AND MATCH (text) AGAINST ('something') AND forum_posts.`date` > SUBDATE(CURDATE(), INTERVAL 9999 DAY) Link to comment https://forums.phpfreaks.com/topic/199286-sometimes-this-query-works/ Share on other sites More sharing options...
fenway Posted April 23, 2010 Share Posted April 23, 2010 Then they are not really identical, now, are they? Link to comment https://forums.phpfreaks.com/topic/199286-sometimes-this-query-works/#findComment-1047062 Share on other sites More sharing options...
cartpauj Posted April 23, 2010 Author Share Posted April 23, 2010 Then they are not really identical, now, are they? Thanks so much! That was just the answer I was looking for...I need search no longer. Look if that's all you have to say you might as well have kept it to yourself. Link to comment https://forums.phpfreaks.com/topic/199286-sometimes-this-query-works/#findComment-1047087 Share on other sites More sharing options...
fenway Posted April 26, 2010 Share Posted April 26, 2010 Snarky, aren't we? I'm just indicating that your premise is incorrect. Let that guide you. Link to comment https://forums.phpfreaks.com/topic/199286-sometimes-this-query-works/#findComment-1048545 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.