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

Popular posts from this blog

javascript - Google App Script ContentService downloadAsFile not working -

javascript - Function overwritting -

php - Find a regex to take part of Email -