PHP Undefined variable in while loop

Question

Problem

While I am fetching information from mysql, I also want to check that some specify column in mysql row is 0.

But then I get the notice Undefined Variabe yet the code works?

Code Line 157:

        while($row = $fetch->fetch( PDO::FETCH_ASSOC  ) && $row['status'] == 0) {

Error I get

Notice: Undefined variable: row in C:\xampp\htdocs\recover\admin\index.php on line 157

My question:

How do I get rid of that error without creating a if statement under the while loop? I basically want it to handle this in the while loop, if I am not doing that wrong?.

Is using a if statement under the while loop better than using it in the while loop?

What is causing the error? I am already defining what $row is before the && row['status'] == 0.

Thanks

before the while loop assign null to $row

Youn Elan
– Youn Elan

2013-03-30 20:21:45 +00:00
Commented Mar 30, 2013 at 20:21 — Youn Elan
– Youn Elan, Commented Mar 30, 2013 at 20:21

Michael · Accepted Answer · 2013-03-30 20:20:28Z

3

You need parentheses:

while(($row = $fetch->fetch( PDO::FETCH_ASSOC  )) && $row['status'] == 0)

answered Mar 30, 2013 at 20:20

Michael

12.9k6 gold badges57 silver badges69 bronze badges

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

2 Comments

Jony Kale Over a year ago

Oh I get this now.. Thanks a lot!

Joost Over a year ago

Another possibility is to replace && with and, it has other precedence rules. (Although parentheses are much clearer and I always use them around assignments in statements, but that's because of modern C compiler rules which don't apply here)

Collectives™ on Stack Overflow

PHP Undefined variable in while loop

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related