проблем със страницирането на коментари

kiling

Registered
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 но незнам как да ги страницирам какъв трябва да е кода и къде да го сложа
 

Back
Горе