title: Order_by not functioning
body: <p>i have this query but when the output displays its not sorted</p>
  
  <pre><code>function get_productbyid($productid) {
          $this-&gt;db-&gt;select('*')-&gt;from('projquotedetails,products')
                                -&gt;where(array('projquotedetails.productid' =&gt; $productid))
                                -&gt;where('projquotedetails.productid = products.productid')
                                -&gt;order_by('page_order','asc')
                                ;
  
          $query = $this-&gt;db-&gt;get();
  
          if ($query-&gt;num_rows() &gt; 0) { return $query-&gt;result_array(); }
          else                        { return 0; }
  
      }
  </code></pre>