[RESOLVED] mysql while loop with second parameter

[cretaceous]

I'm doing this:

while ($row=mysql_fetch_array($result) && !$agntexistfound){...

and in the while loop if I get what I'm looking for I set

$agntexistfound=1

I would then expect it to exit the while loop on next iteration
- however on the very first iteration my $row values are totally empty -
though it has a rowcount returned of 1

as an alternative I have added this before end of while loop:

if($agntexistfound)break;

which seems fine

but why doesn't the first version work?

[NogDog]

Not sure if this will solve everything, but because of operator precedence ("&&" comes before "="), you probably want to add some parentheses:

while (($row=mysql_fetch_array($result)) && !$agntexistfound){

Otherwise $row will be assigned a boolean result of the && comparison instead of the return value from mysql_fetch_array(). (Alternatively, you could use the "and" operator instead of "&&", as "and" has a lower precedence than "=".)

operator precedence

[cretaceous]

thanks Nogdog - parentheses it is

not sure why I didn't think of that
I'm a bit of an "if in doubt slap in more parentheses" type of preson