[eluser]Unknown[/eluser]
is there any way to write query like this if not than why i can not write query like this because it is very help full
<code>
$query=$this->db
->select('*')
->where('id',1);
echo $query->from('products_categories')->count_all_results();
//here i am getting result what i want
print_r($query->get('products_categories')->result());
//here i am getting all the records without considering the select and where clause
</code>