<?php
include('common.inc.php');
  $sth = $conn->prepare( 'select * from recordings limit 100;');
 
    $sth->execute( );
$recordings = $sth->fetchAll();
$convos = Array();
$convo = Array();
foreach ($recordings as $i => $recording) {
 
        if (count($convo) > 0 && strcasecmp($convo[count($convos)]['tgid'], $recording['tgid']) != 0) {
                $convos[] = $convo;
                $convo = Array();
        } ;
        //print_r($recording);
        $convo[] = $recording;
        //print_r($convo);
        echo "<br>\n";
}
foreach ($convos as $i => $convo) {
        print_r($convo);
        echo "<br>\n";
}
?>