fenway

You're asking about getting the top N records for a given group -- I've covered that many times before on this board.

That's not a job for GROUP BY. Join the table to itself, on (id), and use t1.date > t2.date in the ON clause. Simple as that.

What do you have so far?

What doesn't work is getting back non-group-by fields.

That's up to your script in PHP.

Clearly, you're not searching the forums -- http://www.phpfreaks.com/forums/index.php?topic=342584.0.

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

And you should really include the column list.

What do you want to insert? How is it 3?

No, I mean the user variables. And you should be able to order it however you'd like in the final order by clause.

In the sticky for this board, there are alternatives.

I don't follow.

First, those variables aren't doing anything in this query. Second, the order by clauses inside each select aren't doing anything either. Sort at the very end, after the UNION.

Not every product has 100s of categories.

Actually, just the one query, and it's EXPLAIN output, as specified in the board's sticky.

The difference between the functions on invalid dates isn't.

I don't follow. INSERT doesn't update.

What's too hard to implement -- one query?

What if some of the colours match?

When you use BINARY, you negate index usage.

If you have to attach a script, that means it's too big. It's too big because you're trying to post the entire thing. I already told you not to use great circle distances -- and you ignored me.

It says there are only 11 rows total -- is that true?

This has to stop -- php syntax errors have no place on this forum, especially not one at a time. Post your CREATE TABLE so we can see what collation you're using.

That's exactly what I'm saying -- it's undocumented, and it's evil.

I'm hoping there's a WHERE clause that goes along with that UPDATE. Back to your question -- it really depends on how "something" changes elsewhere in your application.