title: How to order by use in codeigniter
body: <p>My table data is like that</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>NAME</th>
  <th>order</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>1</td>
  <td>English</td>
  <td>0</td>
  </tr>
  <tr>
  <td>2</td>
  <td>Italian</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Spanish</td>
  <td>2</td>
  </tr>
  <tr>
  <td>4</td>
  <td>Hindi</td>
  <td>1</td>
  </tr>
  <tr>
  <td>5</td>
  <td>Bengali</td>
  <td>3</td>
  </tr>
  <tr>
  <td>6</td>
  <td>Tamil</td>
  <td>2</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>my query</p>
  <pre><code>    $this-&gt;db-&gt;select('*');
      $this-&gt;db-&gt;from('languages');
      $this-&gt;db-&gt;order_by('order','asc');
      $query = $this-&gt;db-&gt;get();
  </code></pre>
  <p>I want data like this order-1,1,2,2,3,0</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>ID</th>
  <th>NAME</th>
  <th>order</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2</td>
  <td>Italian</td>
  <td>1</td>
  </tr>
  <tr>
  <td>4</td>
  <td>Hindi</td>
  <td>1</td>
  </tr>
  <tr>
  <td>3</td>
  <td>Spanish</td>
  <td>2</td>
  </tr>
  <tr>
  <td>6</td>
  <td>Tamil</td>
  <td>2</td>
  </tr>
  <tr>
  <td>5</td>
  <td>Bengali</td>
  <td>3</td>
  </tr>
  <tr>
  <td>1</td>
  <td>English</td>
  <td>0</td>
  </tr>
  </tbody>
  </table>
  </div>