how to bypass a warning?

[sangoku]

how can i bypass when a query returns an empty result but that result is fetched by a for each loop mean the warning       

mean  this:

foreach (mysql_fetch_array($resultSql) as $row){

            $result[] = $row;

}

 

[trq]

if (mysql_num_rows($resultSql)) {
  foreach (mysql_fetch_array($resultSql) as $row){
    $result[] = $row;
}
}

 

You are aware however that this will not loop through all results in your query? Just all fields in the single result.

[oni-kun]

Yes, you should rethink your logic and use the tried and true methods available if you cannot figure out how to loop it like so.

[sangoku]

O boy i need straight answers... that happens when by chance there is no match in the db.... usually there are more than one....  AND i dont want notifications

[sangoku]

noo need foun the answer....

 

        if(mysql_num_rows($resultSql)){

        foreach (mysql_fetch_array($resultSql) as $row){

            $result[] = $row;

        }

        }else{

            $result = array();

        }

 

num rows is a good one XD

[trq]

Again though....

 

You are aware however that this will not loop through all results in your query? Just all fields in the single result.

[sangoku]

:'( :-\   Sorry to tell you but I know exactly what i am doing. 4. year IT engineering......

 

I only ask when i dont know how to do what i wana do..... 

[oni-kun]

:'( :-\   Sorry to tell you but I know exactly what i am doing. 4. year IT engineering......

 

I only ask when i dont know how to do what i wana do..... 

 

Go complain to your IT tech instructor about the poor material he has taught.

[ignace]

if (mysql_num_rows($resultSql)) {
  foreach (mysql_fetch_array($resultSql) as $row){
    $result[] = $row;
}
}

 

Are you sure this is what you want:

 

$result[] = 'username';

$result[] = 'e-mail';

$result[] = 'password';

 

Or are you after:

 

$result[] = array('username', 'e-mail', 'password');

$result[] = array('username2', 'e-mail2', 'password2');

..