fenway

Just check the counter in the WHERE clause... not this is the best way.

You don't have a join condition.

What are event files? What version?

You'll need the REPLACE() function for that... but be careful with word boundaries and such.

You can use user variables to mimic row numbering.

Backticks and single quotes are not interchangeable. And post the actual error as well...

Interesting... why the subselect instead of simply using a WHERE clause on "b".

Don't try and re-invent the wheel.

I'm not sure I follow... what makes you think this is incorrect?

Careful... fulltext can be very evil.

This is clearly outside the scope of "mysql".

This is going to be more complicated since you don't have a normalized database design.

What is the "way you want it to work", exactly?

Well, that's not very helpful now, is it.... you'll have to find your mysqld executable, and then figure out where the default location of the config file is... which depends on which of the million flavours of *nix you're running.

This looks a lot like this thread...

SUM() only takes a single parameter... but you can add multiple SUM()s together.

I don't follow.

This comes down to an underlying limitation of the mysql fulltext search functions... you either need to roll-your-own, or use something like sphinx.

I don't see any sql statements being echo'ed as requested.

Why are you trying to do this?

Since I have no idea what codeigniter is, I can't really help you. Sorry. Without mysql statements, there's not much i can do.

No different than setting any other password.

To do this properly, you'll need to LEFT JOIN in the games table with the required three game rows...

Yes, don't mess around with the underlying data.... feel free to make summary tables, though.

Sounds like you just need to map product ids to user ids.