rendered paste body <?
$query = "SELECT * FROM `comments` WHERE `to` in (SELECT email FROM users WHERE email = '$email') ORDER by post_date ASC";
$result=mysql_query($query) or die(mysql_error());
$num=mysql_numrows($result);
$i=0;
while ($i < $num) {
$from = htmlentities(mysql_result($result,$i,"from"));
$comment = htmlentities(mysql_result($result,$i,"comment"));
$post_date = htmlentities(mysql_result($result,$i,"post_date"));
?>
<tr>
<td width="22%" rowspan="2" align="center" valign="top">
<?=$from?>
<br />
<img src="<?=$avatar1?>" width="75" height="75" /></td>
<td width="78%" height="23" align="left" valign="top"><?=$post_date?></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#999999"><?=$comment?>
<p> </p>
<p> </p></td>
</tr>
<tr>
<td colspan="2" align="center" valign="top"><hr /></td>
</tr>
<?
$i++;
}
?>