<?php
     // TOP 10 MESAJ ATAN ÜYELER
mysql_connect('localhost', 'veritabani', 'veritabani);
mysql_select_db('veritabani); ?>

    <? $sql[0] = 'select `username` from `user` order by `posts` desc limit 10';
for ( $i = 0; $i < count($sql); $i++ ) {
    echo '<td><ul>';
    $result = mysql_query($sql[$i]);
    while ( $row = mysql_fetch_array($result) ) echo '<li>' . $row['username'] . '</li>' . "\n";
    echo '</ul></td>';
}

?>

<?php
if (!defined('DOSYA_AYAR')) include 'ayar.php';

$top10uyesonuc = mysql_query("SELECT id,kullanici_adi,mesaj_sayisi FROM $tablo_kullanicilar WHERE kul_etkin='1' order by mesaj_sayisi desc LIMIT 0,10");

$uyesira = 0;

while ($top10uye = mysql_fetch_array($top10uyesonuc))
{
	$uyesira++;
	echo '<br><b>'.$uyesira.')</b> <a href="profil.php?u='.$top10uye['id'].'">'.$top10uye['kullanici_adi'].'</a> ('.$top10uye['mesaj_sayisi'].')';
}
?>