1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 | <?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"; } ?> |