[eluser]sahanlak[/eluser]
Review these 2 methods of SQL query
Code:
$this->db->select('amount')->from('withdraw_request')->where('user_id', $ID)->limit(0, 1);
Code:
$this->db->query('SELECT amount FROM `withdraw_request` WHERE user_id=? LIMIT 0,1', $ID);
I get the number of rows, first one always return 0 means not working, 2nd one works perfect. What's the difference?