PHP - while mysql_fetch_array loop error?

Question

I am using this code to show the users that are administrator:

<?php
while($write = mysql_fetch_array(mysql_query("SELECT * from users WHERE level >1"))){
    echo ''.$write['username'].'';
}
?>

But the page stays loading forever! What is wrong with it?

Jessica · Accepted Answer · 2013-06-21 19:42:52Z

7

It's an infinite loop. You're running the query over and over.

$sql = "SELECT * from users WHERE level >1";
$result = mysql_query($sql) or trigger_error("SQL: $sql - Error: ".mysql_error(), E_USER_ERROR);
while($write = mysql_fetch_array($result)){
    echo $write['username'];
}

*Obligatory "switch to PDO/mysqli_" message here.*

answered Jun 21, 2013 at 19:42

Jessica

6,99630 silver badges39 bronze badges

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

1 Comment

Francisco Presencia Over a year ago

Wanting someone to fill the mysql_* bit for you? There you go (;

Collectives™ on Stack Overflow

PHP - while mysql_fetch_array loop error?

1 Answer 1

1 Comment

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Related