fenway

What do you expect us to do with that?

That's because you interspersed "SET" in between your table joins....

Huh?

This seems like an order of precedence issue... you'll need to wrap your ORs in parens.

No, I want specific examples in your case... sample records from both tables, what output you are trying to achieve with them, how they relate, etc.

Agreed... pls confirm this isn't DB-related, and I'll move it.

Try without spaces in your field names!!!!!

Yes, I saw... IMHO, table structures don't really constitute something to hide. I'll make a one-time exception this time. Keep discussions to the boards for future reference. Why not simply sort by "numleads/numclicks" instead of "convratio"? Problem solved.

You sure you can't combine that logic? Tell us more.

First, show us the EXPLAIN output of your existing query.

Why not try creating it using the "DELIMITER" way?

I prefer proper JOIN syntax, but that's the general idea... you'll need to convert the select to an update with a SET clause, of course.

Short answer... don't format your output in mysql.

Don't post links to code... no one's going to look at them. "Refreshing" is not a mysql problem... if that's really the issue, but the queries work just fine, then I'll move this thread to the PHP forum.

Maybe we're getting closer... could you elaborate with examples?

Yup... so you have to order using an "inverted" FIELD()....

Just not that that code does NOT deal with the situation where there are other values in your list other than the ones your explicit "rank" -- careful.

Sorry, I give up... I really haven't followed this from the outset. Maybe someone else will be able to understand.

Not easy without a stored procedure of app code... parentID isn't the best way to store this -- check out the stickies.

Sure, why not?

Glad to help... would you mind posting the final working query? You'd be amazed how often this question gets asked around here..

So, what's wrong with that?

That sounds like the typical CLIENT_MULTI_STATEMENTS flag issue in php.

Well, this will retrieve the "desired" rows, correct? SELECT il.* FROM issues_log AS il INNER JOIN ( SELECT issue_id, MAX(status_date) AS status_date FROM issues_log WHERE status = 'closed' GROUP BY issue_id ) AS sub USING( issue_id, status_date ) Shouldn't be too hard to count and join it back to issues table.

Not exactly... that's _still_ php code... echo that string. That's the one that's producing the error message, right?