Temos pavadinimas: WordPress, Shopify ir PHPFusion programuotojų bendruomenė :: Gintulio Klausimai/Prašymai

Parašė Narysx· 2009 Rugs. 25 12:09:24
#23

openside ("Šaukyklos Top 10");

$result=dbquery("SELECT user_name, user_location, user_icq, user_id, count(user_id) AS shout_count FROM ".$db_prefix."shoutbox INNER JOIN
".$db_prefix."users ON shout_name=user_id GROUP BY user_name ORDER BY shout_count DESC LIMIT 0,10");
echo "<table width='100%' cellpadding='0' cellspacing='0'>";
if(dbrows($result)!=0){
while($data=dbarray($result)){
echo "<tr><td class='small2' align='left'> <img src='http://wiskas.lt/images/bullet.gif' </a> <a href='".BASEDIR."profile.php?lookup=$data[user_id]' class='side'>";
echo "<img border='0' alt='".$locale['on106']."' title='".$locale['on106']."' src='".BASEDIR."images/avatars/".$data['user_avatar']."'></a></td><td class='small2' align='right'>[$data[shout_count]]</td></tr>";
}
}

echo "</table>";

closeside();
?>




Tiksliai nežinau, ar veiks...

Redagavo Narysx· 2009 Rugs. 25 12:09:35