Welcome Guest, Not a member yet? Register   Sign In
where() showing "IS NULL" instead of variable value
#1

(This post was last modified: 01-02-2018, 04:09 AM by ktmonty.)

Hello guys,

$email=''abc@abc.com';
$pass= 123;

$this->db->select('*')->from('user')->where(' email',$email)->where('password',$pass)-> get()->result();

this gives result :-

'select * from uses where email IS NULL and password IS NULL';

But it works with $this->db->query();

plz help me to find why its not taking like :-

'select * from user where email="abc@abc.com" and password="123" ';

Thanks,
Reply


Messages In This Thread
where() showing "IS NULL" instead of variable value - by ktmonty - 01-01-2018, 11:34 PM



Theme © iAndrew 2016 - Forum software by © MyBB