Separate return from a table to a Timeline

Question

I am creating a Timeline where there may be more than one user update per day.

I need my return sql to already compare the dates and I can separate

$sql = "SELECT * FROM tb_timeline JOIN responsaveis ON id_responsavel = feito_timeline WHERE  para_timeline = '".$_SESSION['id_responsavel_matricula']."' ORDER BY data_timeline ASC ";

these updates record a LOG in a table with what was changed and the date and time of change, I would like in a way that I compare the changes made in the same day and put the indicated class so that Timeline appears only on the left or only on the right.

In the image I put for each log to appear one on one side and the other on the other, however I would like to compare the dates EX: 2018-08-07 appeared on one side and the 2018-08-08 appear from another and so on

To appear on the left side, does not use class, to appear on the right side put the class Inverted"

Answer 1

First search the dates with records:

  SELECT distinct data_timeline  //converter o timestamp para data (dd/mm/yyy ou outro formato apenas de dada)
   WHERE  para_timeline = '".$_SESSION['id_responsavel_matricula']."' 
ORDER BY data_timeline order by data_timeline asc;

after having the dates in an array you can fetch all the records of this date.

 $datas = array('01/08/2018', '02/08/2018'); //resultado da query acima
 foreach($datas as $key => $data){

     //define a classe do box da timeline
     $class = $key % 2 ? '' : 'inverted'; 

     //retornar todos os registros da data 
     $sql = "SELECT * 
               FROM tb_timeline 
               JOIN responsaveis 
                 ON id_responsavel = feito_timeline 
              WHERE para_timeline  = '" .$_SESSION['id_responsavel_matricula'] . "' 
                AND data_timeline  = '" . $data . "' 
           ORDER BY data_timeline  ASC";

    //executa a query e traz os resultados da data em uma variavel ($resultados)

   //percorre os itens da tb_timeline na data atual do primeiro loop ($datas)
   foreach($resultados as $idx => $timeline){
   ?>
      <div class="<?php echo $class ?>">
         <!-- conteudo do item da timeline -->
      </div>
   <?php 
   }
}