fenway

I'm sure there's a faster way... check out the link in my sig and try to re-formulate your question.

Sounds like a simple update statement should work.

Now I don't follow... why not use substring_index() to find the "root folder" and then simply check that against the left-most part of the path field?

If you post the actual queries, that would help too -- not php code.

You just need a LEFT JOIN ..IS NULL to find the missing ones.

MySQL 5 has a CSV engine type.

If what's possible?

You simply need to rotate this log.

Well, you'll always get partial matches with fulltext searching... personally, I don't see anything wrong with that.

Yikes... you need a WHERE clause for every update statement.

I don't follow... could you give an example?

Yikes... what are you trying to do there?

Sounds like your PHP paths are all wrong.

PBXT is still fairly new....

Then you've come to the wrong place/forum.

This is a very common way to handle hierarchies -- it poses some issues for certain types of queries, but usually, it's ok -- mainly because it's the easiest to maintain.

Don't post the code -- show us the actual queries.

I don't see a single mysql query anywhere in there.

What's wrong with plain ol' mysqldump?

"Sending" is not a mysql problem -- confirm that you're getting back the rows you expect.

Say what? What's "dout"?

The error tells you exactly what's wrong... you're missing a parameter.

Forgot about the cron for now.... how might you handle this for a single month?

Not that I'm for comma-separated anything, but FIND_IN_SET() can be your friend.

1,2 and 3 all sound like php questions.