i am getting empty array using the query...

[osclassLover]

$this->dao->select("s_name");
            $this->dao->from('oc_t_category_description');
            $this->dao->where( 'fk_i_category_id', $qs['fk_i_category_id']);
            $this->dao->where( 'fk_c_locale_code', $locale );
            $result = $this->dao->get();
            $s =  $result->result();
            print_r($s);
            exit;

i am using this query for getting s_name field for a category id

but i am getting empty array even if i have value in the variable $qs['fk_i_category_id'].

pls help me someone, thanks .

[teseo]

Hi,

In wich file are you including this code?

Regards

[osclassLover]

i am using this code inside oc-includes/osclass/model/Category.php

i am using this code inside a function and the function has a paramater and that parameter is $qs['fk_i_category_id']

but its giving empty result, i dont know why?...

[osclassLover]

hello  teseo, pls help me , i dont know what to do, i dont know why its not workings...

pls help me out of this problem...

[teseo]

Activate queries.log and look for your custom query, check possible error and see what values are being sent.

http://forums.osclass.org/3-3-x/item-post-location-not-setting/msg117277/#msg117277

Regards