php - Mysql returns no error but don't give any result but in phpmyadmin it returns -
i'm having strange error.
when run sql:
select a.*, (((a.num_artigo not in (select l.num_artigo leiloes l))) | ((1 in (select n.rt leiloes n n.num_artigo = a.num_artigo)) << 1)) type artigos_prazo in phpmyadmin return table supposed be.
but when run in php script not return nothing, receive no error database.
<?php $con = mysqli_connet...; $sql = "select a.*, (((a.num_artigo not in (select l.num_artigo leiloes l))) | ((1 in (select n.rt leiloes n n.num_artigo = a.num_artigo)) << 1)) type artigos_prazo a"; echo $sql; echo mysqli_error($con); $result = mysqli_query($con, $sql); print_r($result); while($row[] = mysqli_fetch_array($result)); print_r($row); mysqli_close($con) ?> it connects database...
help please
replace
while($row[] = mysqli_fetch_array($result)); print_r($row); with
while($row = mysqli_fetch_array($result)) { print_r($row); }
Comments
Post a Comment