PHP код:
$result3 = mysql_query ("SELECT t1.avat, t1.author, t1.date, t1.post, t1.text ,t2.idi ,t2.login FROM comments AS t1 LEFT JOIN users AS t2 ON (t1.author=t2.login) WHERE post='$id' ORDER BY id LIMIT $start, $num",$db);
if (mysql_num_rows($result3) > 0)
{
$myrow3 = mysql_fetch_array($result3);
do
{
printf ("<table align='center' class='avatar' id='box1'>
<tr>
<th width='110px'>
<img aligh='left' src='%s' width='90'></th>
<th><p class ='post_bot'>Комментарий добавил(a): <strong class ='post_bot1'><a href='page.php?idi=%s' rel='external'>%s</a></strong> <br> Дата: <strong>%s</strong></p>
<p class ='post_bot1'>%s</p></th>
</tr></table>",$myrow3["avat"],$myrow3["idi"],$myrow3["author"],$myrow3["date"],$myrow3["text"]= strtr($myrow3["text"], array(
'O:-)'=>'<img src="images/smiles/aa.gif" title="O:-)"/>',
':)'=>'<img src="images/smiles/ab.gif" title="улыбается"/>',
':('=>'<img src="images/smiles/ac.gif" title="грустный"/>',
';-)'=>'<img src="images/smiles/ad.gif" title="подмигиваю"/>',
'*winkwink*'=>'<img src="images/smiles/winkwink.gif" title="*winkwink*"/>',
'8-)'=>'<img src="images/smiles/af.gif" title="В очках жуёт жувачку"/>',
':-D'=>'<img src="images/smiles/ag.gif" title=":-D"/>',
':-['=>'<img src="images/smiles/ah.gif" title=":-["/>',
'=-O'=>'<img src="images/smiles/ai.gif" title="=-O"/>',
':-*'=>'<img src="images/smiles/aj.gif" title=":-*"/>',
'::('=>'<img src="images/smiles/ak.gif" title="::("/>',
':-X'=>'<img src="images/smiles/al.gif" title=":-X"/>',
':O'=>'<img src="images/smiles/am.gif" title=":O"/>',
':-|'=>'<img src="images/smiles/an.gif" title=":-|"/>',
'*blink*'=>'<img src="images/smiles/blink.gif" title="Прыгает от счастья"/>',
'*JOKINGLY*'=>'<img src="images/smiles/ap.gif" title="*JOKINGLY*"/>',
'*zloy*'=>'<img src="images/smiles/aq.gif" title="*zloy*"/>',
'[:-}'=>'<img src="images/smiles/ar.gif" title="[:-}"/>',
'*KISSED*'=>'<img src="images/smiles/as.gif" title="*KISSED*"/>',
':-!'=>'<img src="images/smiles/at.gif" title=":-!"/>',
'*huh*'=>'<img src="images/smiles/huh.gif" title="*huh*"/>',
'*sick*'=>'<img src="images/smiles/sick.gif" title="*sick*"/>',
'*KISSING*'=>'<img src="images/smiles/aw.gif" title="*KISSING*"/>',
'*ohmy*'=>'<img src="images/smiles/ohmy.gif" title="*ohmy*"/>',
'*THUMBS UP*'=>'<img src="images/smiles/ay.gif" title="*THUMBS UP*"/>',
'*DRINK*'=>'<img src="images/smiles/az.gif" title="*DRINK*"/>',
'*IN LOVE*'=>'<img src="images/smiles/ba.gif" title="*IN LOVE*"/>',
'@='=>'<img src="images/smiles/bb.gif" title="@="/>',
'*HELP*'=>'<img src="images/smiles/bc.gif" title="*HELP*"/>',
'\m/'=>'<img src="images/smiles/bd.gif" title="\m/"/>',
'%)'=>'<img src="images/smiles/be.gif" title="%)"/>',
'*OK*'=>'<img src="images/smiles/bf.gif" title="*OK*"/>',
'*WASSUP*'=>'<img src="images/smiles/bg.gif" title="*WASSUP*"/>',
'*SORRY*'=>'<img src="images/smiles/bh.gif" title="*SORRY*"/>',
'*BRAVO*'=>'<img src="images/smiles/bi.gif" title="*BRAVO*"/>',
'*ROFL*'=>'<img src="images/smiles/bj.gif" title="*ROFL*"/>',
'*PARDON*'=>'<img src="images/smiles/bk.gif" title="*PARDON*"/>',
'*NO*'=>'<img src="images/smiles/bl.gif" title="*NO*"/>',
'*CRAZY*'=>'<img src="images/smiles/bm.gif" title="*CRAZY*"/>',
'*sex*'=>'<img src="images/smiles/sex.gif" title="*sex*"/>',
'*DANCE*'=>'<img src="images/smiles/bo.gif" title="*DANCE*"/>',
'*YAHOO*'=>'<img src="images/smiles/bp.gif" title="*YAHOO*"/>',
'*HI*'=>'<img src="images/smiles/bq.gif" title="*HI*"/>',
'*BYE*'=>'<img src="images/smiles/br.gif" title="*BYE*"/>',
'*YES*'=>'<img src="images/smiles/bs.gif" title="*YES*"/>',
';D'=>'<img src="images/smiles/bt.gif" title=";D"/>',
'*WALL*'=>'<img src="images/smiles/bu.gif" title="*WALL*"/>',
'*WRITE*'=>'<img src="images/smiles/bv.gif" title="*WRITE*"/>',
'*SCRATCH*'=>'<img src="images/smiles/bw.gif" title="*SCRATCH*"/>'
)));
}