用LIKE进行SQL查询

I have a weird problem please take a look at this query:

select * from myfriend where name like "%n%";

when execute this query on phpMyAdmin the query returned correct results, but when execute it using php no result returned.

please note this query executed in drupal 6.

what is the problem with char "n" and PHP?

Percent signs are used as placeholders in Drupal 6 queries, so you need to escape them:

$query = db_query('select * from myfriend where name like "%%n%%"');

$searchChar = "n";

$query = "SELECT * FROM `myfriend` WHERE `name` LIKE '%" . $searchChar . "%'";

Then use the $query variable in your statement.

Eg:

$mysql->query($query);

mysql_query($query);

Your query is perfect. Give some brief on it. You can check if your connection of database from php to mysql is correct. You can echo that query from php file and run into phpmyadmin if that gives correct output then surely database connectivity problem will be there.

There is absolutely no issues with any character in php.