How could varchar field in Mysql table can accept values without single quote in query where clause
MRM_RA1_ID='".$_SESSION['EmployeeID']."' (Not working)
MRM_RA1_ID=".$_SESSION['EmployeeID']." (Working)
MRM_RA1_ID is varchar field
I am not getting this behaviour. Mysql version is 5.1.
Can someone please explain me.
Because it is taking value of $_SESSION['EmployeeID'] Just take its value as variable value. And if you want simple string then single quotes must be used.
VARCHAR_FIELD = $Variable
VARCHAR_FIELD = 'Any data'