fenway

You can't use GROUP BY and get back multiple columns.

Wait a sec... won't score always be equal to minutes_online_month in your example above?

Hard to see without table prefixes... but you'll need to add a condition of OR absence.person_id IS NULL".

Don't mark it "solved" unless you've posted the solution for the beneift of others.

Very true... and please limit your code snippets to only the error-causing portion

I don't see why you need to use table1 at all.

You can use GROUP BY as required in your mysql query, but that really depends on how you're dealing with the downstream output.

Feel free to push onto an array if you so choose.

Are you talking about writing the INSERT statment?

Besides, there's a sticky that has a similar resource as well.

I've just tried this and it doesn't seem to work. Is there any way to put a ' in a variable or in a mysql table field? Then you didn't do it correctly.

I have no idea what you're getting at.

Use LEFT( yourField, 50).

Huh?

Most client API will return affected rows.

Your "solution" has nothing to do with the record problem.... you simply called fetch() before you started your loop.

Every field has a collation... shouldn't make any difference on a numeric UID field.

Tables can't "need" commit... transactions exist on the statement level.

Huh? Is the problem with the query or the script?

You have not provided any additional information... you don't have access to this command, as per your host's configuration.

What's the problem...?

Switch to HAVING, not WHERE.

You could simply update a recent activities table, I suppose.

Don't model anything facebook does for your site, or vice versa. It doesn't apply.

Isn't this continued for another topic??? And I have no idea what you mean.