Thread: Getting stale, inaccurate results from a Select query?

We're using ZF 1.7.7 on our current project, and we've got a big query that joins a number of tables together. The problem is that one field is returning old results that aren't in the database anymore. I've tried writing select statements to get the field itself, and that reflects the current database values. And if I run the big query in PHPMyAdmin (I'm using $select->assemble() ) it also shows the correct values. It's only on the one big query, and only for that one field. If I change one of the other fields, the big query shows it properly.

We're not using cacheing or anything, and I've tried flushing the tables and all that.

So.. has anyone seen this before? Any idea how to resolve this?

Thanks!