fenway

You simply want to find all time ranges that include a portion of your range?

When you say "efficiently", do you mean speed alone?

Sorry, I don't follow.

Remove the extra parents.

Unless it's InnoDB.

Multiple databases are really annoying -- unless you're dealing with Big Data.

Sounds like a quoting issue.

What does "stopped working" mean?

I don't need to see a DOC -- but your WHERE clause doesn't check for LOGOUT = 0.

I don't understand why you just don't change the field -- you want it to be DVD and BLU-RAY?

You wouldn't need to check if you were using a DB class that made it impossible.

See here.

That couldn't be more specific.

Please don't do that -- don't troll multiple forum web-sites for answers -- otherwise, you're just wasting our time.

At least get the slow_query_log.

I mean, you say it works for up, not down. Give me an example of input & output for both cases, in English.

I'm not good with tutorials -- maybe someone else has a suggestion. But that's the logic of pseudo-code.

Try: select table1.USR_ID, table1.USR_PARENT, table1.USR_MONEY, table1.USR_FAMILY, balances.childSum FROM table1 LEFT JOIN ( select USR_FAMILY, sum( USR_MONEY) AS childSum from table1 where USR_PARENT = 0 group by USR_FAMILY ) AS balances USING ( USR_FAMILY ) Untested -- should be close.

Are the letters that appear fixed?

I recently stickied a good resource.

That's a PHP error -- and usually it gives you a line number.

I still don't see what UNIQUE and auto-increment have to do with one another.

Interesting. Never knew you could put a conditional in the ORDER BY. Yup -- any expression -- that why ORDER BY FIELD() works. Incidentally, MySQL knows about zero dates -- you can just refer to them as '0' in your clauses -- much easier, and less error-prone.

Huh?

"a SUM of all sub-account balances for anyone who is a parent" Is that a simply SUM(), GROUP BY, where usr_parent = 0?