title: php mysql asc/desc order
body: <p>TABLE:</p>
  
  <pre><code>**timeslot**:
  ----------
  id_timeslot   times
  1             09:00
  2             09:30
  3             10:00
  4             10:30
  5             11:00
  
  **bookslot**
  id   id_timeslot     date        b_ref
  -------------------------------------------
  1    2               2010-02-22  001 
  2    3               2010-02-22  001
  3    4               2010-02-22  001
  4    5               2010-02-22  001
  5    2               2010-02-25  002
  6    3               2010-02-27  003
  7    4               2010-02-27  003
  8    5               2010-02-27  003
  </code></pre>
  
  <p>PHP</p>
  
  <pre><code>$q = $mysqli-&gt;query("SELECT * FROM bookslot  
  LEFT JOIN timeslot ON bookslot.id_timeslot = timeslot.id_timeslot   
  WHERE bookslot.status = 1 
  GROUP BY bookslot.b_ref  
  ORDER BY bookslot.date ASC, bookslot.id_timeslot ASC LIMIT 20");
  </code></pre>
  
  <p>HTML RESULT:  </p>
  
  <pre><code>DATE         TIMES  
  2010-02-22   10:30
  2010-02-25   09:30
  2010-02-27   11:00
  </code></pre>
  
  <p>anyone notice that on the table result. the times is incorrect order?<br>
  i changed another way round with ASC / DESC, and still the times showing the last id_timeslot?</p>
  
  <p>EXPECTED RESULT:</p>
  
  <pre><code>DATE         TIMES  
  2010-02-22   09:30
  2010-02-25   09:30
  2010-02-27   10:00
  </code></pre>