fenway

All I want in the actual text of the mysql query...nothing more.

Oh, I see now -- we need to use the most recent closed status. BTW, why do you have two status flags?

Solved how? There isn't even a mysql query in there!

I'm sorry... I'm quite lost now. Is there a counting issue or a grouping issue? And why should certain rows be excluded? Your sample data doesn't match your output, either.

The query that's causing the error -- I want to see it (not the php code).

Wait a minute, that doesn'twork?

Huh?

first write a query to find the matches, then worry about counting them....

That's so very exposed to sql injection... echo your query string.

no, i mean: SELECT il.status_date AS sdt, COUNT(i.id) AS cnt FROM issues AS i LEFT JOIN issues_log AS il ON ( i.id = il.issue_id AND il.status='closed' ) WHERE i.status = 'closed' GROUP BY sdt ORDER BY sdt ASC

You need to figure out the "highest" state first, then join back

TLDR.. what's wrong now?

And please don't ever post that much code again.

Get rid of those evil backticks.

INT UNSIGNED should suffice for most tables... are you really going to store over 4 billion records in any given table?

Or write a quick three-liner to do it regardless -- check if magic quotes are on, and then addslahes accordingly.

Sorry, I have no idea what you're talking about. And this was even more confusing. Start again.

LEFT JOIN ... IS NULL might be faster.

Code like that doesn't help at all. What exactly is the problem? Have you echoed your sql statements.

Yikes... look at some dev resources on storing trees in mysql.

".TCSH OS 10.5 Intel quad" is quite confusing. I assume you're using the tcsh shell (finger -m username will tell you for sure). You can simply search the web for examples.

Plenty of tutorials on this site, too.

This would be much easier if you have a contractors table too... and normazlied as well.

This the standard "groupwise-max" question that has been answered many times over. It's covered in one of the stickies, too.

I don't understand.