fenway

What makes you think you need to partition this table?

And SET needs to come earlier in the syntax.

"To no avail" -- do you still get the results you did before?

Sorry, I was confused by "solved".

Why 2 separate queries?

It is on case-sensitive file systems -- it has no choice.

Care to post the solution?

Well, if you can ensure that there's only one level of nesting, then a simple join should be able to generate that list.

Almost -- add "where table2.userID is null".

Where do you check these differences?

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=327106.0

If by "breaking" you mean "no results", then you need LEFT JOIN, not commas.

Don't store multiple values in a single field.

LEFT JOIN... IS NULL.

This sounds a lot like the other topic you just started.

What's runaway categorization?

This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=327031.0

That's not very helpful. My apologies if it came off that I was being mean or abrupt; but the rules even say to try something yourself before asking for help. The fact that a google search found his answer is not me being unhelpful, I pointed him in the right direction. (Something you've done to me a few times ) At the very least, some URLs might have helped.

Also, the "URGENT" is against the ToS -- and free assistance can never be urgent.

Again, that's a PHP error. There's a PHP help forum for that. If your DB query isn't failing, you're in the wrong place.

Oh, the count in the subquery -- I misunderstood.

An UPDATE without a WHERE clause -- very scary.

That's not very helpful. What's the purpose of this new column?

You needed "IS NULL", not a NOT IN.

Then you looked up something else.