fenway

Why are you single quoting everything????

Yeah, it's the whole 1970 vs epoch thing.

MySQL won't combine individual column indexes for FULLTEXT -- use the combined one.

Huh?

mysql_select_d()?

Bad idea - just have a single rss table.

Check mysql_error() after the offending query.

Sorry, we (myself & mysql) don't believe it. LEFT JOIN and I'll bet you'll see NULLs.

I think you can simply using RENAME DATABASE as of version 5.something -- check the refman.

That's because you're likely running in strict mode -- if you say something has to be a string, and you don't insert anything, and the default isn't a string, then that's considered data corruption.

You're missing AUTO_INCREMENT.

That's quite enough.

Like I said... echo the full query.

Well, since you're named the index the same, you need to drop the other one first -- or give it a different name.

Don't double-post -- first & last warning.

If you're talking about auditing, you'll need to have the DB wrapper log this somehow (triggers, inserts, meta data, query logs, etc.) and then report it yourself.

Then there are no matches in the non-leading tables.

What does that even do? OP: you're talking about paging nwo?

Echo the ACTUAL query you're sending to the server -- and you'll see.

Then update a "modified" field, and check that afterwards.

Sounds like a JOIN.

Sure... SELECT INTO OUTFILE.

Nope -- but depending on what you need, you can always store the unix timestamp in microseconds as a BIGINT UNSIGNED.

Sorry, I don't follow -- why can't you just update a status field?

SQL_CALC_FOUND_ROWS() is much, much slower than COUNT(*) -- don't return the actual result set if all you need in a count.