PHP:
<?php
}
$qc = mysql_query("SELECT * FROM comments WHERE type = 'profile' AND p_id = '".$_GET['id']."' ORDER BY id DESC LIMIT 5");
while($rc = mysql_fetch_array($qc)){
$quc = mysql_query("SELECT * FROM users WHERE id = '".$rc['us_id']."'");
$ruc = mysql_fetch_array($quc);
$qup = mysql_query("SELECT * FROM pictures WHERE us_id = '".$ruc['id']."' AND pind = '1'");
$rup = mysql_fetch_array($qup);
if(mysql_num_rows($qup) < 1){
$rup = "default/default_small.gif";
} else {
$rup = "small_thumb_".$rup['picture'];
}
$qlike = mysql_query("SELECT * FROM likes WHERE type = 'cprofile' AND t_id = '".$rc['id']."' AND us_id = '".$userdata['id']."'");
$rlike = mysql_fetch_array($qlike);
if($userdata['id'] != $rlike['us_id']){
$like = "Харесва ми";
} else {
$like = "Не харесвам";
}
?>
<div id="<?php echo $rc['id'] ?>" class="b r">
<table width="100%" border="0" cellspacing="2" cellpadding="2">
<tr>
<td width="10%" align="center" rowspan="2" valign="top"><a href="index.php?p=profile&id=<?php echo $ruc['id'] ?>"><div style="border: 1px #CCC solid; width: 50px; height: 40px; padding: 2px;"><div style="background-image: url(uploads/photos/<?php echo $rup ?>); background-position: center 25%; width: 50px; height: 40px;"></div></div></a></td>
<td width="90%">
<?php
if($r['id'] == $userdata['id'] || $ruc['id'] == $userdata['id'] || level($userdata['id'], '3') > 2){
?>
<div align="right" style="float: right; margin-left: 5px;">
<a href="index.php?p=us_ac&type=delete_comment&id=<?php echo $rc['id'] ?>&us=<?php echo $r['id'] ?>" title="Изтриване на коментара?"><img src="images/icons/delete.png" align="absmiddle" /></a>
</div>
<?php
}
?>
<a href="index.php?p=profile&id=<?php echo $ruc['id'] ?>"><b><?php echo $ruc['title'] ?></b></a>: <?php echo text($rc['comment']) ?>
</td>
</tr>
<tr class="line">
<td><small><?php echo date('d.m.Y - H:i', $rc['date']) ?><?php if($_SESSION['login']){ ?> · <a href="#" class="favorite" id="<?php echo $rc['id'] ?>_cprofile_<?php echo $rc['us_id'] ?>" /><?php echo $like ?></a><?php } ?></small></td>
</tr>
</table>
</div>
<br />
<?php
}
?>
</div>
</div>
</td>
</tr>
</table>
имам код за коментари които взимам от база данни показват се последните 5 но незнам как да ги страницирам какъв трябва да е кода и къде да го сложа