fenway

Duplicate topic - http://www.phpfreaks.com/forums/index.php?topic=356569.0.

You're working up to a ban with all of this cross-posting.

Don't mark topics solved without posting the solution.

It's unicode -- case-insensitive -- and one of the "general" collations that includes "common" characters.

All these subqueries make me think something is horribly wrong.

Then please post the final working query.

Where's your GROUP BY clause?

SUM() of datetimes doesn't make any sense.

Oh, it can be done -- it just might be easier to calculate in PHP if this is a "one-time" thing, and then update the corresponding rows.

Sorry, I don't understand the question.

Then why not get all the parents first, then a second query to get their children? Or at least process the results sepearetly?

SQL isn't designed to operate on pairs of rows -- you'll have to fake it with a user variable, or use a self-join, assuming you "know" how to find record N+1.

Assuming you told it to do so with mysqldump.

Or you can use NOT EXISTS.

Agreed -- done.

FYI, that would negate the use of an index -- you might want to add a "fake" time to the RVALUE instead.

Please stop posting your code. And you really shouldn't be posting your DB credentials either -- but as you'll notice from the error message, you're not actually using the password.

If you read the posting rules, you'll notice that we'll need much more information to help you.

I always prefer: select columns from table where date <= NOW() + INTERVAL 7 DAY

+1

What?

I've heard nothing but horror stories about them.

Covers: Part 1: Using the MySQL Improved Extension, mysqli Part 2: Using the MySQL Extension, mysql Part 3: Using the PDO Extension With MySQL Driver, pdo_mysql Part 4: Using the MySQL Native Driver for PHP, mysqlnd Tutorial is here.

Well, a scalar subquery, that is.

Hopefully this presentation will stay online at scribd... it's simply fantastic, probably the best I've come across in recent memory. At 220 slides, it's quite lengthy -- but the lessons learned are invaluable, so be sure to read all the way to the end. A MUST READ!!!! EDIT: This year's version of the presentation -- some really great stuff in here, particuarly about hierarchies.