fenway

Why doesn't the header row have commas?

Alias the expression instead: if(did = 0, u.usergroupid as gid, u.displaygroupid as gid) becomes if(did = 0, u.usergroupid, u.displaygroupid) as gid

You'll need a table of answers too... don't limit it to 5.

No. Yes.

Well, a subquery in the field list can only return a *single* value -- and I don't see a CONCAT().

That's a php logic issue.

Does the query itself return the correct resultset?

Well, a multi-valued insert would be faster, but that's up to you.

I don't understand what you're trying to do.

Huh? More detail, please... you're lucky I didn't delete this thread outright.

Well, won't ech individual part have different properties & attributes, too?

Huh?

Sounds like you need UNION.

My guess is that you're returning more than a single row in that subquery.

Always good to feel appreciated (not me, per se, the whole forum).

You mean like this? select i.* from g_images as i left join g_rates as r on (r.Gid = i.id) where r.Gid is null

Post your solution, please.

Then share with the rest of us.

Where are you getting these magic numbers?

Ignoring the fact that you're misusing GROUP BY for a minute, that's very odd -- what if you remove the where clause?

Don't post login credentials -- or entire scripts, for that matter! Are you sure you've connected to the right DB?

How?

Run the EXPLAIN for each of those.

You've not helped anyone but yourself... could you post the solution for the rest of us?

a LEFT JOIN?