fenway

You'll have to join it back to the main table.

Drop the single quotes... and there's no "AND" for a column list.

Use COUNT(*) and GROUP BY cat, sub.

You're asking if DELETE will also SELECT? No, it won't. if you want both, you have to do both.

What's wrong with a db abstraction layer?

Huh?

I'm sorry, I don't understand.

I belive there's a UDF for filesystem stuff... but you should be able to "mark" your records appropriately regardless.

You can easily work around that... use a cartesan join in definitely worse.

You can use INTERVAL to save doing the math.

Yes, what is your definition of "update" here...?

Sorry, I thought you were the OP... my bad.

Yikes... let's start again.... why can't you simply count the number of posts per thread???????

yikes... talk about an table in need of normalization......

Second link; slide #68 onwards -- the "closure set" -- is a very practical implementation!

If you COUNT(fieldName) instead of COUNT(*), you will exclude NULLs.

It's called "UNION.

You can't find the "last" order unless you store temporal data somehow.

Yes... you didn't specify a column type for the UID field.

Show us the value of $sql.

GROUP_CONCAT is your friend.

Actually, "_" (underscore) is the single character marker and "%" (percent) is the multi-character marker.

I don't understand the question -- I was trying to figure out why they weren't being updated. But ultimately if you import "blank" then you'll get blank -- not null.

Well, you'd need to count by venue first.

Check the LENGTH() of these fields to see what's going on.