fenway

Yes, but why not use BETWEEN?

It means just that... there's a deadlock that timed out. No problem... just restart the transaction again.

INSERT INTO... SELECT WHERE???

Echo the actual statement being sent to the server.

Don't *ever* post entire code blocks like that -- totally useless. You're new, so I guess you didn't know. Consider yourself warned. That error means there was something wrong with the query -- if you echo your query, and post it here, it should be obvious.

I don't understand, sorry.

what's wrong with subqueries?

You've stored multiple keywords in a single field... show the query you're using now.

That's a bit of a mouthful... there are plenty of "common sense" rules, too.

show all three table structures.

I'm not sure I understand what the problem is... are you updating data or adding new data every month?

Why wold you break the connection?

What is the actual statement being sent to the server?

You were just given the code...

TLDR... care to summarize?

What about: CREATE TRIGGER Progress_chi_ai AFTER INSERT ON Progress_chi FOR EACH ROW BEGIN UPDATE Progress_par SET percentage = ( SELECT AVG(percentage) FROM Progress_chi WHERE parent_id = NEW.parent_id ) WHERE parent_id = NEW.parent_id; END;

I understand what you mean, but I'm trying to figure out if the select statement is actually getting back more than the "first" town for each user.

Because then only one of the conditions needs to be "in range".

Again, if you're talking about using mysql data that has been successfully retrieved, you're in the wrong forum....

Can you post the table structures?

Don't double-post next time.

Try: DELETE demand, services FROM demand INNER JOIN services ON (demand.source=services.name) WHERE services.name = 'TEST' I'm assuming that you want to delete both rows...

Solved how?

Echo $sql... and what about magic quotes?

There isn't even a query here... are you sure this is a mysql issue?