it is not able to retrieve correct value from variable in WHERE clause

it is not able to retrieve correct value from variable in WHERE clause

References

Reference NO 1

http://stackoverflow.com/questions/17845999/how-can-i-pass-a-variable-to-a-where-clause-using-mysqli

Reference NO 2

http://stackoverflow.com/questions/8605488/mysql-where-clause-not-working-it-should-select-active-0-but-it-selects-everythi

Reference NO 3

http://community.qlikview.com/thread/60352

Reference NO 4

https://forums.oracle.com/thread/2551966

Reference NO 5

http://www.bigresource.com/MS_SQL--Passing-variable-to-where-clause-in-sql-query-from-a-grid--yJhIR79d.html

Reference NO 6

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/3a134276-42e2-4797-affc-3e6fa65782a9/action?threadDisplayName=variable-not-working-in-where-clause

Reference NO 7

http://www.vodahost.com/vodatalk/mysql-php/55482-clause-php-doesnt-work-variable.html

Reference NO 8

http://infocenter.sybase.com/help/topic/com.sybase.infocenter.dc00801.1510/html/iqrefso/X315771.htm