works on local server but not live

[edbr]

im sure im missing something obvious, i just cant see it any more.
i had a fail on a site as i tried live, i tried to break the problem down i found the error as below with a foreach and an if condition.
This is working fine on my local server but not live.

 $sql = "SELECT * FROM data"; 
    $result = mysqli_query($test,$sql);
    mysqli_fetch_array($result );
    foreach($result as $row){
        if( $late['area']=='Sanur'){
    echo  $row['title'].'<br>';
        }}      

It has to be something basic i am sure but im cooked!

[pritaeas]

http://php.net/manual/en/mysqli-result.fetch-array.php

mysqli_fetch_array returns a row, so you should store that in a variable.

[edbr]

thnk you , i got it working using PDO but I could not see why it would worl locally and not live

[jj.dcruz]

there are some specification on hosting sites sometimes to make it more secure. but localy you dont need much security on a standalone computer or your localhost.

[cereal]

In addition, you could use mysqli_fetch_all() to retrieve all the rows:

$result = mysqli_fetch_all($query, MYSQLI_ASSOC);

foreach($result as $key => $row)
{
    echo $row['title'].'<br>';
}

But it requires Mysqlnd (the native driver):

• http://php.net/manual/en/mysqli-result.fetch-all.php
• http://php.net/manual/en/book.mysqlnd.php

[edbr]

got it done with below. thx

        $sql= "SELECT * FROM villadata ";
$result = $test->query($sql);
while($row = $result->fetch_array())
{
$rows[] = $row;
}   
foreach($rows as $row)
{
 if( $row['area']=='Sanur'){
    echo  $row['title'].'<br>';
        }}