fenway

What?

So there's no "proper" foreign key?

it's "exists", but yes.

You should be able to handle this trivially in PHP.

So let's switch to INNER JOIN for now (i'm assuing there are matching rows). Could you show some sample output?

Add "WITH ROLLUP" to your group by. Aside: Drop the DISTINCT.

Ugh -- Word. Basically any editor that respects DOS/UNIX filetypes.

Wait a minute... you can't have taskid being auto-increment in *TWO* places?!?!

Could you post the table structure so we can try it on our end?

Why right join?

I would NOT worry about those settings -- if you're server has those set, don't change them in the backups. As for editing, use wordpad, not notepad.

Post the query that's causing that error-- not the code.

Seems like it doesn't like the gs...

I'm sorry I still don't understand... 1..6 refer to column offset??

You can "fake" fields with "AS".

That would be easier to read & maintain using JOINs, but yes.

Well, you can turn strict mode off -- at least back to the 4.1 settings -- but not sure that's what you want.

Hmm... what about a left join to itself?

Yes, let's see the actual statment.

I'm sorry, I still don't follow... could you give a concrete example?

Define "not working" -- maybe it's a self-table thing.

mysql has replace().

What errors do you get from mysql? I don't see any FKs in the table defs.. and you're supression errors.

Sounds like you're in strict mode now.

Huh? What do you want the records to look like in the end?