A strange problem: the same SQL statement can be found in mysql, but cannot be found in php.

A very strange problem: the same SQL statement can be found in mysql, but cannot be found in php as follows:
Data table structure in mysql:


SQL statement:
Select id from tradeDetails WHERE userName = 'Lily' AND goodsID = '1'

Php code:

When I put the SQL statement in mysql, one record can be found, but the record cannot be found during php page execution. .

Reply to discussion (solution)

Mysql_query ("set names utf8 ");

Php files are also UTF-8 encoded.

Php files are UTF-8 encoded.

The first two positive solutions, Hey, should be encoding problems...

Thank you! At the prompt of the moderator on the first floor, I found that my code was wrong and changed UTF-8 to utf8! Not much. I just divided it out on average.