CURRENT_TIMESTAMP {$qry_filter_clients} {$qry_filter_areas} GROUP BY nome, u.user_id ORDER BY quantidade DESC "; $sql = $conn->query($sql); $data = array(); if ($sql->rowCount()) { foreach ($sql->fetchAll(PDO::FETCH_ASSOC) as $row) { $data[] = $row; } } else { $data[] = array( "nome" => TRANS('NO_RECORDS_FOUND'), "quantidade" => 1 ); } $data[]['chart_title'] = TRANS('SCHEDULED_X_WORKERS', '', 1); // IMPORTANT, output to json echo json_encode($data); ?>