PHP

<?php
//DEMO http://hostdcp.com.br/teste/2tabela.php

include('../config.php');

$sql_pagos_reservados = MySql::conectar()->prepare('SELECT `tb_site.rifas`.`titulo`,`tb_site.rifas`.`capa`, `tb_site.rifas`.`id`,`tb_site.test`.`rifas_id`, COUNT(`tb_site.test`.`type`) AS SomaType FROM `tb_site.rifas` RIGHT JOIN `tb_site.test` ON (`tb_site.rifas`.`id`=`tb_site.test`.`rifas_id`) WHERE `tb_site.test`.`type` GROUP BY `tb_site.rifas`.`id`,`tb_site.test`.`rifas_id` ');
$sql_pagos_reservados->execute();
$rifaindex_pagos_reservados = $sql_pagos_reservados->fetchAll();

    $count=0;
        while(list($key, $value) = each($rifaindex_pagos_reservados)) {

            $tipo = $value['SomaType'];


    $count++;



    echo $tipo.'<br>';







} ?>