Вывод ТОП комментариев

<? 
$result7 = mysql_query("SELECT avka,author,count(*) AS CNT FROM komments_lec GROUP BY author ORDER BY count(*) DESC LIMIT 7",$db);
$myrow7 = mysql_fetch_array($result7);
do
{
$r1 = $myrow7["CNT"];
printf ("<p>%s %s. Комментариев: $r1</p>",$myrow7["avka"],$myrow7["author"]);
}
while ($myrow7 = mysql_fetch_array($result7));
?>

<? 
$result = mysql_query("SELECT avka,author,count(*) AS CNT FROM 
(SELECT avka,author,count(*) AS CNT FROM komments_lec) 
UNION 
(SELECT avka,author,count(*) AS CNT FROM komments_metod)
 all data
GROUP BY author ORDER BY count(*) DESC LIMIT 10]")  or die(mysql_error());
while ($row = mysql_fetch_array($result))
{
   echo "Авка : {$row['avka']} <br>" . "Имя : {$row['author']} <br>" . "Комментариев : {$row['CNT']} <br><br>";
}
?>

<? 
$res = "SELECT *, count(*) AS CNT FROM 
(SELECT author,avka  FROM komments_lec 
UNION ALL 
SELECT author,avka FROM komments_metod) all_data 
group by author order by count(*) desc limit 7";
 
$result7 = mysql_query($res);
while ($row = mysql_fetch_array($result7))
 
{
echo "Авка : {$row['avka']} <br>" . "Имя : {$row['author']} <br>" . "Комментариев : {$row['CNT']} <br><br>";
}
?>

function showPopup(obj) {
            var imag = "<?php
                include('mysql_connect.php');
                $peremen = obj;
                $result=mysqli_query($dblink, 'SELECT photos.path FROM photos WHERE id_obj="'.$peremen.'";'); 
                $r = mysqli_fetch_array($result); 
                $res = $r['path'];
                echo $res;
                ?>";
}

 $tor = "SELECT * FROM dani_lec WHERE MATCH (title) AGAINST ('$search')"; 
$result = mysql_query($tor);

 $tor = "SELECT * FROM
        (SELECT title FROM dani_lec
        UNION ALL
        SELECT title FROM dani_metod) all_data
        WHERE MATCH (title) AGAINST ('$search')"; 
        $result = mysql_query($tor);