fenway

Unless you're using bind parameters, it's always better to quote strings -- particularly if you're writing raw SQL via PHP.

That doesn't really matter -- take the UPDATE, write the equivalent SELECT,and check EXPLAIN.

Where's the mysql problem here?

Sounds like you're asking the same question again -- don't do that -- wait for a response. Topic locked.

That means 'create the indexes on the columns above' -- you're currently performing joins on un-indexed columns.

Then you're going to have to provide table definitions and sample data -- which, by the way, is requested & required by the posting guidelines.

team_points.team_id is one of the missing indexes. payments.user_team_id is another.

The fact that it's an ENUM has absolutely no bearing on updating the values.

You're missing AND and OR in your WHERE clause without parentheses.

We're happy to help -- but you've only provided some PHP code -- I can't possibly guess what that's doing.

Again, we're not going to debug your code for you -- show us an INSERT statement.

Start by telling us what part of the database queries doesn't work.

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

Let's start by looking at EXPLAIN output for both queries.

Can you give a concrete example?

There wasn't an error, it only output a single RequirementType, there's 6 rows in that table. Then show us the data in the rows you expect to see.

That JOIN you were provided with should work -- what's the error?

Care to elaborate on that node-style solution?

Yeah, and soggy corn flakes are disgusting.

I'm not one to open attachments -- but a new dedicated user sounds like the way to go.

Well, you posted apache error messages about a file not exists. And connecting to mysql as 'root'? Definitely not the solution.

Welcome back.

If you're joining, you'll need at least one index per joined table.

More importantly, never combine first and last names into a single column.

You haven't given us tables. You haven't given us the offending queries. How are we possibly supposed to help?