current community

your communities

more stack exchange communities

Stack Exchange
tour help
stack overflow careers
Take the 2-minute tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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?

share|improve this question

1 Answer 1

up vote 7 down vote

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.*

share|improve this answer
    
Ow thanks I thought I could just make it in one line! –  John Balls Jun 21 '13 at 19:45
    
Wanting someone to fill the mysql_* bit for you? There you go (; –  Francisco Presencia Jun 21 '13 at 19:45

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.