fenway

That's impossible... it won't update other fields... there must be another statement somewhere.

You'll need to use an IN() for the mysql... and you'll have to get php to give you a comma-separated array.

Well, it's not.

No-one can possibly understand that query formatted as such.

Not helpful whatsoever... and use code tags next time... except don't post the whole code anyway.

What does the error log say?

Or with a CASE statement: UPDATE yourTable SET bankmoney = CASE WHEN bankmoney >= 50000 THEN bankmoney*.02 ELSE bankmoney+1000 END Assuming NULL isn't an option.

Is your DB query working? Because this sounds like a PHP issue.

That '@' sign isn't leading....

Tested what?

you sure that's a proper variable?

Because you have no join condition, amongst other things.

Find that strange.... it should be taking up at least ~20MB regardless because of buffer sizes in the my.cnf file. Try running this script and see what you get.

How?

Just realize that this solution may not be thread-safe.

It's only "low" when compared to SELECT statements.

You can only retrieve the value you used to aggregate the COUNT()... in this case, "fieldname"... which means that if you want the other value for the "top" record, you'll need to join this back to the original table.

Or EXTRACT(YEAR_MONTH FROM GA_Gig.date) = '200810'

You CANNOT use * with group by.

Should be able to MOD that rather easily.

Well, have you read the refman page on LOW_PRIORITY/

No need for view or SPs unless it's really complex.

You could always have started the server and skipped grants.

It's impossible that echo-ing a single line messes up the rest of the page.

Please echo $sql.