Q:

What is the correct method in where_in? 

i want to get data using where in condition 
my code is below
SELECT `cuc_UserCardsDetail`.*,  `cuc_CreditCardType`. `varValidName`
FROM (`cuc_UserCardsDetail`)
JOIN `cuc_CreditCardType` ON `cuc_CreditCardType`. `intGlCode` = 
`cuc_UserCardsDetail`. `fk_CardTypeGlCode`
WHERE `cuc_UserCardsDetail`. `intGlCode` IN ('10,29') 
AND `chrAccountType` =  'M'
ORDER BY `dtCreateDate` desc

now I have resulted with one row actually in my table there is two-row with related id 
i think problem is In('10,29') but i want like ('10','29') or (10,29) how can i do in codeigitor? 
i want (10,29) or ('10','29') in where in ..

A:

In CI query builder use
$id= array('10', '20'); # or direct assing your input params
$this->db->where_in('column_name', $id);

Read Looking for Specific Data - Codeigniter.com

