fenway

Probably the delimiter.

Sorry, I don't follow.

Forgetting about performance for a moment, a simple order by clause and some variables/counters should do the trick.

Then you'll need to order by each part separately.

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

You know, if you're going to post your question elsewhere, at least have the courtesy to post the solution when you find it.

Why is it "wrong"?

Might be a firewall/port issue.

You mean just an expresion based on placement?

You can always re-create just the MYI.

With GROUP BY.

That's purely a connection issue... probably temporary.

well, you can translate the date into a daynumber(), and then modulus appropriately for group by.

I don't follow -- you have the correct ordering already?

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

Highest score from all games, or each game?

No, not really -- you'd have to know the IDs, in the desired order, to replicate that.

The server still has to run the statement anyway.

You probably want to SUM(), with an inside IF().

So, solved?

What does that even mean?

Ah, yes, I see what you're saying. That's always going to be true -- rand() can't possibly guess. You have a few options: 1) Just increase the number of rows you return randomly, if you can easily the "miss rate". This works well if you don't need "exactly" N rows back. 2) Do (1) iteratively, since maybe you will get back the right number sometimes -- can't imagine that a few extra passes wouldn't sort this out. 3) This may be very bad performance-wise, but if your "expired" query runs quickly, you can always use those UIDs directly -- but that's quite ugly.

There isn't a single sql query is that block -- moving thread. This topic has been moved to PHP Coding Help. http://www.phpfreaks.com/forums/index.php?topic=312693.0

Not really -- you obviously have the ingredient list already -- so what's the problem?

You're using COUNT and SUM interchangeably.