Sometimes this query works...

[cartpauj]

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)

[fenway]

Then they are not really identical, now, are they?

[cartpauj]

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.

[fenway]

Snarky, aren't we?

 

I'm just indicating that your premise is incorrect.  Let that guide you.