Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include('../../config.php');
- $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` = 123
- 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 $numeros = 'RIFA TITULO '.$titulo.' RIFA NUMEROS '.$numeros_rifa.'<br>';
- //echo $numeros1 .= 'RIFA NUMEROS '.$value['number'].',';
- $count++;
- } ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement