PHP/MySQL returns no result and no error

I have a si开发者_开发百科ngle MySQL query created from PHP 5. The Query has 3 SELECT and 2 JOIN clauses. It accesses two databases on a single host using one connection and db1.table1 db2.table2 techniques. I echo the query before running. In PHP the query returns no result and does not error. When I copy and paste the echoed query into SQL in PHPMyAdmin, it returns the correct result.

Why is PHP different to the SQL part of PHPMyAdmin and does anyone have any suggestions about getting it to work in PHP?

Why is PHP different to the SQL part of PHPMyAdmin

It's not.

You're connecting to the wrong database, writing the wrong query, or checking for errors incorrectly.