easports Posted January 4, 2007 Report Share Posted January 4, 2007 Aceros foruma viens keks bija iebazis to fignju kjip kad rada top10 banotakie admini butu velams ja jus man iedotu link vai arii pateikt ka to atrast es mekleju nevarejua trast ;( Link to comment Share on other sites More sharing options...
naziic Posted January 4, 2007 Report Share Posted January 4, 2007 Nū es gan neesmu to fig\nu redzējis, bet tu negribi vnk pats izvilkti visu no db??? Link to comment Share on other sites More sharing options...
samuray Posted January 4, 2007 Report Share Posted January 4, 2007 top10 banotakie admini kaapeec vispaar admini jaabano? Link to comment Share on other sites More sharing options...
easports Posted January 4, 2007 Author Report Share Posted January 4, 2007 kaapeec vispaar admini jaabano? ja bik nokljudijos bet tu sparati ko es ar to domaju bet ja tev nedalec tad bija domats ta ka rada majs lapa 10 adminsu kuri visvairak uzlikusi banu Link to comment Share on other sites More sharing options...
JuiCe Posted January 4, 2007 Report Share Posted January 4, 2007 A ja tu zini ka te jau bija viens ielicis, tad panem mekkletaju un samekle! Link to comment Share on other sites More sharing options...
easports Posted January 4, 2007 Author Report Share Posted January 4, 2007 A ja tu zini ka te jau bija viens ielicis, tad panem mekkletaju un samekle! oo ja mulki es jau mekleju to nevareju atrast vieta to ka kaukadus sudus raksit butu vnk link iedevis nevis pretigos postus krajis pamulkis Link to comment Share on other sites More sharing options...
Thesnake Posted January 4, 2007 Report Share Posted January 4, 2007 (edited) yay <? mysql_connect("localhost", "root", "") or die(mysql_error()); mysql_select_db("amxbans") or die(mysql_error()); $query = "SELECT admin_nick, COUNT(admin_nick) as banaani FROM amx_bans GROUP BY admin_nick ORDER BY banaani DESC Limit 10"; $result = mysql_query("$query") or die(mysql_error()); echo "<table border='0' width='180' cellspacing='0' cellpadding='1'> <tr> <td align='center'>#</td> <td align='center'>admins</td> <td align='center'>bani</td> </tr>"; while($row = mysql_fetch_array($result)){ $ranks = $ranks+1; echo " <tr> <td align='center' width='20'>". $ranks .".</td> <td width='180'>". $row['admin_nick'] ."</td> <td align='center' width='50'>". $row['banaani'] ."</td> </tr> "; } echo "</table>"; ?> Edited January 4, 2007 by Thesnake Link to comment Share on other sites More sharing options...
Recommended Posts