View file gallery/best_comment.php

<?php
include_once'./header.php';
include_once'./func.php';
$user_id=$id;

echo"ТОП 10 самых комментируемых фото:<br/>";
$q=mysql_query("SELECT * FROM photos ORDER BY (SELECT COUNT(*) FROM photos_comments WHERE photo_id=photos.photo_id) DESC LIMIT 0,10 ;");
while($a=mysql_fetch_array($q))
{
	echo"<a href='./photo.php?photo_id=$a[photo_id]&amp;$linkstr'><img src='./get_preview.php?photo_id=$a[photo_id]' alt=''/></a><br/>";

	$uploaded=get_rus_date($a[uploaded]);			

	echo"<small>Загружена $uploaded</small><br/>";

	$r_c=mysql_result(mysql_query("SELECT COUNT(*) FROM photos_comments WHERE photo_id='$a[photo_id]' ;"),0);

	echo"Комментарии: $r_c<br/>";
	echo"<br/>";
}
	echo"<a href='./index.php?$linkstr'>Галерея</a><br/>";
include_once'./footer.php';
?>