fenway

Are you sure innodb is actually running?

I don't know what phpmyadmin is doing -- what about "Show table status"?

That's what I'm here for ;-)

What's showing you 87 vs 35? What does "SHOW TABLES" produce? Single database?

Actually, just to be annoying, there is -- auto_increment_increment ;-)

Sphinx is one of the better choices.

You're not listening -- it's per connection -- no matter how many you insert.

InnoDB? MyISAM? Both?

"NOT LIKE"?

Well, that query isn't very selective -- region probably return many matches. Try an index on Profils.DerniereVisit.

Also, for non-ascii, bytes <> characters.

What was wrong with your original query?

First, I think your query doesn't work the way to you expect, since you're mixing AND and OR conditions without parentheses. Second, just change "ISNULL(LOG_IN)" to "LOG_IN=0".

Why can't you just find the date of their last non-win (tie/loss), and then simply count all the records after that?

What have you tried so far?

Without the query, we can't possibly help.

Try (untested) SELECT person FROM results AS r1 INNER JOIN ( SELECT MAX(result) AS result, year FROM results WHERE class = '<desiredClassValue>' GROUP BY year ) AS r2 USING( Result, year ) WHERE r1.class = '<desiredClassValue>'

As root, type "SHOW GRANTS for 'user_name'@'locahost'", and see what happens.

Echo the $sql variable each time.

No -- auto-increment is per connection.

Well, you can do all sorts of fancy things with views and permissions. But are you talking about letting a remote application connect to your DB directly? Sounds like a bad idea.

But Barand already told you this.

First, start by posting the working query.

That error isn't from mysql.

Assuming you only want (a) a single category per item, and (b) no subcategories, then yes.