something messed up with comments

[quickstopman]

i have a user system with profiles and profile comments and stuff of the sort

but ive got one problem

when i post a comment on someones profile

when i try to reload it

i get a 500 server error after about a minute of waiting

 

here is the code for the comments page

<?

if (eregi("comments.php", $_SERVER['SCRIPT_NAME'])) {
    Header("Location: people.php"); die();
}

include("config.php");
$id = $_GET['id'];
$sql = mysql_query("SELECT * FROM `profile_comment` WHERE user_id = '{$id}' ORDER BY timedate") OR die(mysql_error());

echo "<table>";

$comments = mysql_fetch_array($sql);
while($list = $comments) {
echo "
<tr>
<td>From:<br>
{$list['user']}
</td>
<td></td>
{$list['comment']}
</tr>";
}

echo "</table>";

?>

thanks

[hitman6003]

You created an infinite loop with your while statement.

 

change

 

$comments = mysql_fetch_array($sql);
while($list = $comments) {
echo "
<tr>
<td>From:<br>
{$list['user']}
</td>
<td></td>
{$list['comment']}
</tr>";
}

 

to

 

while($list = mysql_fetch_array($sql)) {
echo "
<tr>
<td>From:<br>
{$list['user']}
</td>
<td></td>
{$list['comment']}
</tr>";
}

[quickstopman]

i knew it was something simple like that

thanks