PHP while looping endlessly instead of iterating through MySQL table rows

Question

I can't figure out why this keeps breaking my page. Could someone take a look? Thanks!

while ($row = mysql_fetch_array(mysql_query("SELECT * FROM `mytable` WHERE `col1` = 0"))) {
    echo $row['id'];
}

I've seen this type of while loop show up pretty regularly in google searches and just browsing through stackoverflow. I don't know why it isn't working for me.

How would I achieve the desired result? (Echo the id of each row where col1 = 0)

Cthulhu · Accepted Answer · 2013-08-17 20:07:18Z

6

Obviously it is because you create new MySQL resource with every iteration and then use it's first row.

Use something like

$res = mysql_query("...");
while ($row = mysql_fetch_array($res)) {
    echo $row['id']'
}

By the way, you do know that mysql is deprecated, do you not?

answered Aug 17, 2013 at 20:07

Cthulhu

1,3711 gold badge13 silver badges26 bronze badges

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

Comments

clifdensprit · Accepted Answer · 2013-08-19 14:56:45Z

0

$result = mysql_query("SELECT * FROM `mytable` WHERE `col1` = 0");
while ($row = mysql_fetch_array($result)) {
    echo $row['id'];
}

answered Aug 19, 2013 at 14:56

clifdensprit

4,8968 gold badges36 silver badges59 bronze badges

Collectives™ on Stack Overflow

PHP while looping endlessly instead of iterating through MySQL table rows

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related