How to search Punjabi regional language keyword in mysql

[naresh_staplelogic]

http://stackoverflow.com/questions/29881417/how-to-search-punjabi-regional-language-keyword-in-mysql

 

i am getting different result when running query using PHPMyAdmin and using PHP script.

It is our regional language Punjabi keyword ਹਰਪ੍ਰੀਤ ਕੌਰ ਪਟਿਆਲਾ

I am executing below MySql query using PHPMyAdmin

  

 select * from postinfo where match(info) against('ਹਰਪ੍ਰੀਤ ਕੌਰ ਪਟਿਆਲਾ')

Giving me accurate result.


But when running same Query using PHP form Search

**Code:**   

   

$name=trim($_POST['name']);
    $sql="select * from postinfo where match(info) against('$name') LIMIT 10";
    $result=mysql_query($sql);

Then the result is blank.


Image getting result using mysql query in PHPMyAdmin
http://i.stack.imgur.com/SX20C.png

Edited April 27, 2015 by naresh_staplelogic

[Barand]

Ask MySql why.

 

Add this line to the above code

if (!$result) die(mysql_error());

Note that mysql_ functions are deprecated - you should be using mysqli or PDO functions