Mysql returns no error but don't give any result but in phpmyadmin it returns

Question

I'm having a strange error.

when i run this sql:

select a.*, (((a.num_artigo NOT IN (select l.num_artigo from leiloes l))) | ((1 in (select n.RT from leiloes n where n.num_artigo = a.num_artigo)) << 1)) as TYPE from artigos_prazo a

in phpmyadmin it return a table as it was supposed to be.

but when i run it in a php script it does not return nothing, also I receive no error from the database.

    <?php
    $con = mysqli_connet...;
    $sql = "select a.*, (((a.num_artigo NOT IN (select l.num_artigo from leiloes l))) | ((1 in (select n.RT from leiloes n where n.num_artigo = a.num_artigo)) << 1)) as TYPE from 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 to the database...

Help please

Forget the explain, was just a try :/ Sorry, the sql is the same in both scripts — user3389452, Jun 15 '15 at 10:14
You are traversing $result with the wrong syntax. Check the answer to this similar question: http://stackoverflow.com/questions/14456529/mysqli-fetch-array-while-loop-columns — Masiorama, Jun 15 '15 at 10:22
I said to check the answer, not the question. Look at the accepted one and see the syntax to use with while and mysql_fetch_array. — Masiorama, Jun 15 '15 at 10:41
I'm getting no error, that's the problem. Simple the array $result and $row are empty. But running the same SQL command on the terminal I have a result — user3389452, Jun 15 '15 at 11:33

score 0 · Answer 1 · answered Jun 15 '15 at 12:43

0

Replace

while($row[] = mysqli_fetch_array($result));
print_r($row);

with

while($row = mysqli_fetch_array($result)) {
    print_r($row);
}

answered Jun 15 '15 at 12:43

Alexander

19,906
19
75
162

Mysql returns no error but don't give any result but in phpmyadmin it returns

1 Answers1