fenway

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.

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

So, solved?

What does that even mean?

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.

Sorry, I don't follow.

No, I don't.

I have no idea what you'er trying to do, but CASE, as you've used it, is the wrong idea.

* and GROUP BY don't mix.

You cannot use * and GROUP BY.

What's wrong with a JOIN?