Web page not loading with PHP-MySQL code while outputting JSON

Question

I am using the code below to get information from a database and make it into JSON (it may be wrong).

Unfortunately it won't load in my web browser, it just says it's loading but it doesn't finish. Please can you tell me what I am doing wrong.

$query = mysql_query("SELECT * FROM Posts ORDER BY date DESC") or die(mysql_error());
$array = array(); 
while ($row = mysql_fetch_assoc($query)) { 
$array[] = $row; 
$postID =     $row['id']; 
while ($ra = mysql_fetch_assoc(mysql_query("SELECT * FROM Comments WHERE postID = '$postID'"))) { 
$array['comments'] = $ra; 
} 
while ($rd = mysql_fetch_assoc(mysql_query("SELECT * FROM Likes WHERE postID = '$postID'"))) { 
$array['likes'] = $rd;
 } 
} 
echo json_encode($array);

a1ex07 · Accepted Answer · 2011-06-08 23:39:22Z

3

You are executing mysql_query in the infinite loop: on each iteration you query the database, and fetch the first row. Change it to

$res = mysql_query("SELECT * FROM Comments WHERE postID = '$postID'");
if (!$res)
{
   // handle error
}
while ($ra = mysql_fetch_assoc($res)) 
{
 ....
}

And the same for your second query.

answered Jun 8, 2011 at 23:39

a1ex07

37.4k12 gold badges94 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

Web page not loading with PHP-MySQL code while outputting JSON

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related