All pastes #988056 Raw Edit

Stuff

public text v1 · immutable
#988056 ·published 2008-04-17 05:29 UTC
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>&nbsp;</p>
		<p>&nbsp;</p></td>
	  </tr>
	  <tr>
		<td colspan="2" align="center" valign="top"><hr /></td>
	  </tr>
    <?
	$i++; 
	}
	?>