<?php
include('../../config.php');
//$password = isset($_POST['password']) ;
//$senha = $password;
$sql = MySql::conectar()->prepare('SELECT DISTINCT
    `tb_site.rifas`.`titulo`, `tb_site.test`.`number`
FROM
    `tb_site.test`
LEFT OUTER JOIN `tb_site.user` ON
    (
        `tb_site.user`.`id` = `tb_site.test`.`user_id`
    )
    INNER JOIN `tb_site.rifas` ON
    (
        `tb_site.rifas`.`id` = `tb_site.test`.`rifas_id`
    )

WHERE
    `tb_site.user`.`cpf_usuario` = "083diego"
GROUP BY
    `tb_site.rifas`.`titulo`,`tb_site.test`.`number`');
    //"'.$_SESSION['cpf_usuario'].'"
        $sql->execute();
         $rifaindex = $sql->fetchAll();


                                $count=0;
                                while(list($key, $value) = each($rifaindex)) {
                                    //$reservados = 1;
                                    //echo $nome = 'ID '.$value['id'].'<hr>';
                                    //echo $numeros = 'USUARIO ID '.$value['user_id'].'<hr>';
                                    //echo $numeros = 'RIFA ID '.$value['rifas_id'].'<hr>';
                                    //$titulo = $value['titulo'];
                                    //$numeros_rifa .= $value['number'];
                                    echo 'RIFA TITULO '.$value['titulo'].' RIFA NUMEROS '.$value['number'].'<br>';
                                    //echo $numeros1 .= 'RIFA NUMEROS '.$value['number'].',';
                            $count++;



}







/*SELECT
    rifas_id,
    GROUP_CONCAT(NUMBER SEPARATOR ',') AS lista
FROM
    `tb_site.test`
    RIGHT JOIN `tb_site.user` ON(
        `tb_site.user`.`id` = `tb_site.test`.`user_id`
    )
    WHERE
    `tb_site.user`.`cpf_usuario` = 123
GROUP BY
    `tb_site.test`.`rifas_id`*/










?>


<h2>Olá usuário <?=$_SESSION['nama'];?> Seja bem vindo ?</h2>


<a href="./../sair.php">Sair</a>