title: SQL GROUP rows by day then groups in DESC (Still need help)
body: <p>Right now i'm just ordering all the rows by DESC, but i want to put the rows that are created the same day into groups and the groups in DESC.</p>
  
  <p>This is what i currenly have:</p>
  
  <pre><code>$sql3 = "SELECT * FROM test3 WHERE aktiv LIKE 'Ja' ORDER BY date DESC ";
  $result = mysqli_query($conn, $sql3);
  </code></pre>
  
  <p>This is my table:
  <a href="https://i.stack.imgur.com/s4Zh3.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/s4Zh3.png" alt="enter image description here"></a></p>
  
  <p>So it will echo out all the rows that where created on 17 first then 16 and 14 into groups, then i can echo out the date of the different groups. So do i need to use GROUP BY or first find the dates then put it into groups. </p>
  
  <p>I have tried different ways of doing it, but its so many different answers around and can't find the right solution for me, so i need a bit of help. </p>