title: How to mySQL ORDER BY in this case
body: <p>I have this <code>table</code> and trying to show data <code>ORDER BY</code> but based on multiple column.</p>
  
  <p><strong>Table:</strong></p>
  
  <pre><code>_______________________________________________
  id | title | dis | cityid | dist | queue | date
  _______________________________________________
  1  |  abc  | 1   |  1     |  0   |  1    | 2017
  2  |  cde  | 1   |  1     |  0   |  1    | 2017
  3  |  efg  | 1   |  1     |  0   |  1    | 2017
  4  |  ghi  | 1   |  1     |  0   |  1    | 2017
  5  |title1 | 1   |  1     |  1   |  1    | 2017
  6  | title2| 2   |  1     |  2   |  2    | 2017
  7  | abc   | 2   |  1     |  0   |  2    | 2017
  8  | cde   | 2   |  1     |  0   |  2    | 2017
  9  | efg   | 2   |  1     |  0   |  2    | 2017
  </code></pre>
  
  <p><strong>Goal:</strong></p>
  
  <pre><code>titl1
  abc
  cde
  efg
  ghi
  titl12
  abc
  cde
  efg
  </code></pre>
  
  <p><strong>Query:</strong></p>
  
  <pre><code>$sql = "SELECT * FROM district ORDER BY title ASC, queue ASC";
  </code></pre>
  
  <p>Also i tried:</p>
  
  <pre><code>$sql = "SELECT * FROM district ORDER BY title ASC, dist ASC";
  </code></pre>
  
  <p>But none of these works, any suggestion?
  Also i have free ability to add/remove column or change data (like dist, queue) to implement this.</p>
  
  <p>Those data that have dis = 1 are sub group of title 1, and those have dis = 2 are sub group of title 2, title1 and 2 are hading.</p>
  
  <p>For first query result is:</p>
  
  <pre><code>    abc
      cde
      efg
      ghi
      titl1
      titl12
      abc
      cde
      efg
  </code></pre>