fenway

What is your wait_timeout set to?

Nothing has changed -- you have old mysql drivers.

MySQL has many date functions -- including MONTH() and YEAR(). Not sure what you want for the second one.

What conditions are you trying to check?

This is fairly rudimentary stuff -- there are lots of tutorials on this site that can help you out with syntax and flow.

What's not working?

See -- locked.

Yes -- this is what kickstart just said.

See my response to your other post -- and lets' try and keep this related topic all is a single thread, ok?

Just combine the results, in application code, from each table's fulltext search. Otherwise, you're stuck with (a) writing your own or (b) a third-party solution like Sphinx.

You have to use - INTERVAL 7 DAY, not just "7".

What mysql version?

Well, as long as whatever you group by is UNIQUE, you're ok -- at least in mysql.

FULLTEXT doesn't handle small data sets very well.

Assuming the QC is on, every non-deterministic query makes it way into the cache -- which isn't always a good thing.

Well, you can always replace it... or query the I_S tables first.

I'll say it again -- php syntax errors really have no place on this board.

No, you can't span multiple tables with fulltext -- but you can run multiple queries and combine the results.

You need to make a single fulltext index with all the columns you want to incloude.

Referring to this topic -- I should have moved it instead of having a re-post.

This is a job for application code.

Define "not work" -- and show us the actual query.

Well, you can build the query knowing what the user is searching for -- but otherwise you need fulltext searching of some sort.

You seem to have strange quotes all over the place.

You can't protect files across machines unless you encrypt the drive -- otherwise, ACL is your friend.