fenway

"Another DB table"? Which table? How is is related?

Yes, I see. Well, for each record in your temp table, you'll need to query the other tables to see if there are any matches. If so, use that UID. If not, INSERT, then grab the new UID.

I see dozens of queries and 50K of posted code. How about only posting the offending query?

FTS is weird and magical -- like dragons. It misbehaves on very small datasets -- this is a known limitation.

You need a third table linking movieID to userID -- preferably with a timestamp, too.

There are lots of reasons to use such a loop -- though I doubt this case is one of them.

Sorry, I don't follow -- why is there a temporary table?

I've told you not to double-post before -- last warning.

How about showing us your table structure and the queries you're running, instead of making us guess?

That's because you're missing a JOIN condition.

I can't find the INSERTs in that code.

Technically, you should be counting in each subquery and then summing.

That's a great way to start.

Echo the actual query.

How many threads can you open on what appears to be the exact same query?

FYI, UPPER() still won't guarantee a case-sensitive match.

You can't use a subquery to examine a table created in another subquery.

Huh?

Wait -- you just want to show the first 5 awards a given member has? Simple JOIN with LIMIT.

Please, please stop posting all of your code.

But you shouldn't.

You have two things called "invoiceTable"?

5.1 has a event scheduler... but cron really is the way to go.

Agreed -- done.

I've heard nothing but horror stories about them.