"mysqli_fetch_array", not working in my code 1

[lupidol]

Hi everyone,
The following code is the most simple I could get to make me understand how to work with 'mysqli_fetch_array'.

    <?php
    require ('mysqli_connect.php'); 
    $sql="SELECT 'fname', 'email', 'pass' FROM 'list'";
    $row=mysqli_fetch_array($result,MYSQLI_NUM);
    while ($row !== NULL)
    {
    echo $row[0] . '. ' . $row[1] . ' ' . $row[2];
    echo '<br />';
    }
    mysqli_close($dbcon);
    ?>

That code produces the following error message:
Can anyone advise me how to make that code work? What "MYSQLI_NUM" stands for?
Thanks

 

[ChrisHirst]

http://www.w3schools.com/php/func_mysqli_fetch_array.asp

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[ChrisHirst]

Oh and why isn't it working?


Dunno, does $result has a value (other than false, which is what the error suggests)?

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[lupidol]

Thanks,
That code finally worked and why it hadn't worked before I'll compare both codes and have my conclusions.

 

[ChrisHirst]

It's probably because your original code, as posted here, missed out the step of converting a query

$sql="SELECT 'fname', 'email', 'pass' FROM 'list'";

to a query result object

$result=mysqli_query($con,$sql)

So $result was undefined (false) when you tried to use it.

$row=mysqli_fetch_array($result,MYSQLI_NUM);

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum

 

[lupidol]

Thanks ,
Another thing I was not aware of is: you need to run

$row=mysqli_fetch_array($result,MYSQLI_NUM);

each time in order to step to a next data row...
Thanks again

 

[ChrisHirst]

Yep, that's why it is most often run in a "while" loop in 'tutorials'

while ($row = .... ) {
....

}

Chris.

Indifference will be the downfall of mankind, but who cares?
Time flies like an arrow, however, fruit flies like a banana.
Webmaster Forum