Weak: one SQL statement, phpmyadmin can be executed, mysql console can be executed, but php execution reports an error

Weak explosion: one SQL statement, phpmyadmin can be executed, mysql console can be executed, php execution is reported wrong PHP execution & nbsp; said PhpMyadmin is not executed through this column & nbsp; mysql & nbsp; run SELECT & nbsp; userinfo. *, ofUser. email, ofUser. weak c explosion: an SQL statement that can be executed by phpmyadmin, mysql console, and php
PHP execution says there is no such column


PhpMyadmin runs through
 

Mysql runs through


SELECT userinfo. *, ofUser. email, ofUser. creationDate, ofUser. modificationDate FROM userinfo inner JOIN ofUser ON (userinfo. username = ofUser. username) WHERE 1 and (ofUser. creationDate> 1326816000000 and ofUser. creationDate <1327075200000) limit 0,100

For joint queries from two tables, the userinfo ofUser tables use username as the link and use it as the inline condition.
It is strange why PHP reports an error saying "Unknown column 'ofuser. creationdate' in 'where clause.
CreationDate is a varchar (15) that stores unix time strings, similar to 001356757981309 (in milliseconds)
However, you can directly compare them without using single quotes, because the results of PhpMyadmin and mysql are correct.

Phpmyadmin mysql php
------ Solution --------------------
In which table is the creationDate column?
------ Solution --------------------
Check whether all your tests are in the same environment?