Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- include("conn.php");
- ?>
- <html>
- <head>
- <title>Lista Bannati CruserMt2</title>
- </head>
- <body bgcolor="black" text="white">
- <table border="5" width="30%" align="center">
- <tr><th>Posizione</th><th>ID ACCOUNT</th><th>STATUS</th></tr>
- <?php
- $query = mysql_query("SELECT * FROM account WHERE status NOT LIKE 'OK' ORDER BY login DESC LIMIT 100");
- $i=1;
- $num=mysql_num_rows($query);
- while($i < $num){
- $row=mysql_fetch_array($query);
- $name=$row["login"];
- $level=$row["status"];
- if ($i>=4){
- $pos=$i."<sup>th</sup>";
- }elseif ($i==1){
- $pos=$i."<sup>st</sup>";
- }elseif ($i==2){
- $pos=$i."<sup>nd</sup>";
- }elseif ($i==3){
- $pos=$i."<sup>rd</sup>";
- }
- ?>
- <tr><td><?php echo $pos; ?></td><td><?php echo $name; ?></td><td><?php echo $level; ?></td></tr>
- <?php
- $i++;
- }
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement