Using mysql_fetch_assoc in a while loop with extra condition

Question

Why is $row empty when I apply the while loop with mysql_fetch_assoc with an extra condition, but when the extra condition is not there, returns something, is this logical?

while ($row = mysql_fetch_assoc($result) 
        && $gen->getMailsSent() < 499) {
     //blah blah
}

In the above code, the compiler enteres the loop, but $row is empty

while ($row = mysql_fetch_assoc($result)) {
     //blah blah
}

In this one, the compiler still enteres the loop, but then $row returns something, this to me i dont get and is not logical, can someone please explain why this occurs?

can you show the rest of your code? Can't tell much about it from that — imulsion
– imulsion, Commented May 28, 2013 at 8:06

griffin · Accepted Answer · 2013-05-28 08:07:13Z

3

while (($row = mysql_fetch_assoc($result))
        && $gen->getMailsSent() < 499) {
     //blah blah
}

Try this. Your problem is precedence - you actually tell it to

$row = (mysql_fetch_assoc($result) && $gen->getMailsSent() < 499)

See http://php.net/manual/en/language.operators.precedence.php

"&&" comes before "=" in the list, so it gets evaluated first.

answered May 28, 2013 at 8:07

griffin

1,2598 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

kelunik · Accepted Answer · 2013-05-28 08:07:23Z

1

try

while (($row = mysql_fetch_assoc($result)) 
        && $gen->getMailsSent() < 499) {
     //blah blah
}

actually it shouldn't be empty, it should be a boolean.

answered May 28, 2013 at 8:07

kelunik

6,9492 gold badges44 silver badges73 bronze badges

Comments

score 0 · Accepted Answer · 2013-05-28 09:03:36Z

0

Use while loop like this:

while (($row = mysql_fetch_assoc($result))  && ($gen->getMailsSent() < 499)) {
    code goes here..
}

hope this will help..

edited May 28, 2013 at 9:03

answered May 28, 2013 at 8:09

user2393867

Collectives™ on Stack Overflow

Using mysql_fetch_assoc in a while loop with extra condition

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related