title: How to order 1,2,3 not 1, 10, 11, 12 in mySQL
body: <p>The following code outputs in order of 1, 10, 11, 12 of id.</p>
  
  <p>I want to make it 1,2,3,4...</p>
  
  <p>Could anyone tell me what I should do please.</p>
  
  <pre><code>$Q = $this-&gt;db-&gt;query('SELECT P.*, C.Name AS CatName FROM products AS P LEFT JOIN categories C ON C.id = P.category_id');
  </code></pre>
  
  <p>Thanks in advance.</p>