fenway

Sure... SELECT t.teamName AS opponents, IF( LM.matchHomeID = '1', 'home', 'away' ) AS playedWhere FROM core_matches LM JOIN leaguestats_teams t ON ( t.teamID = IF( LM.matchHomeID = '1', LM.matchAwayID, LM.matchHomeID ) ) WHERE ( LM.matchHomeID = '1' OR LM.matchAwayID = '1' ) AND LM.matchSeasonID = '4' ORDER BY LM.matchDate, opponents

That's likely because REGEXP need a lvalue of expr.

No, a "true" TEMPORARY table type, that resides in memory, not on disk.

setTimeout and scrollIntoView.

Define "redirect".

What code is causing "object not found" to be thrown?

Huh?

Well, you can probably get away with Math.round() with the usual * 100, / 100 game.

Then there's something wrong with the way php is handling this... that's php output, not mysql output.

Acutally, it is valid that way... but try removing all parameters to GROUP_CONCAT().

And what does it do now?

Try this (untested): SELECT t.teamName AS opponents FROM core_matches LM JOIN leaguestats_teams t ON ( t.teamID = IF( LM.matchHomeID = '1', LM.matchAwayID, LM.matchHomeID ) ) WHERE ( LM.matchHomeID = '1' OR LM.matchAwayID = '1' ) AND LM.matchSeasonID = '4' ORDER BY LM.matchDate, opponents

Yes, unless you need info from another table.

That doesn't answer the question.

I don't know of any specific tutorials, and it doesn't sound like pseudo-code will be helpful at this point... anyone?

Again with the performance, eh? It's not meant to update multiple tables in the same script... it's meant for updates that require joining multiple tables to produce the result.

You just need to JOIN in those other tables... but it sounds like you want GROUP BY, not DISTINCT.

Because you're looking in php, not mysql. And no, there is a function for this... LPAD().

Suggestions for what?

That was my hunch, too....

So why not use temporary tables, one for each instantiation of the script?

So where do you stand with your code right now?

It's a simple onblur event handler... but you do need rounding, etc.?

What line number? I can't wade though all of that code.

Your'e talking about toggling the display attribute of the element's style... with setTimeouts.