Did you put the PHP debug on in the preferences?

What errors do you get when you apply the query in phpMyAdmin?

PHP and MySQL version?

You know it started working out of the blue, I didn't change anything. To be honest I think I'm at a point to blow it away and start over. I'm lucky as the group has another temp site they are using and killing this one is no biggy. Because it seems that I fix one issue and another pops up it just seems better to wipe it clean.

I do appreicate everyone's help I did learn a lot in trying to troubleshoot these weird things. But it is time to start fresh.