Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <html>
- <title>Lorenc likes men</title>
- <body>
- <h1 align='center'>Top 20 killers</h1>
- <?php
- $server = "SERVERNAME";
- $username = "USERNAME";
- $password = "PASSWORD";
- $db= "DATABASE";
- mysql_connect($server, $username, $password);
- mysql_connct_db($db);
- $result = mysql_query("SELECT KILLS, NAME FROM player_data ORDER BY KILLS LIMIT 20");
- $id = 0;
- echo "
- <table>
- <tr>
- <td>Position</td>
- <td>Name</td>
- <td>Kills</td>
- </tr>
- ";
- while ($row = mysql_fetch_array($result, MYSQL_ASSOC))
- {
- $name = $row['KILLS'];
- $kills = $row['NAME'];
- echo "
- <tr>
- <td>$id</td>
- <td>$name</td>
- <td>$kills</td>
- </tr>
- ";
- $id ++;
- }
- mysql_close();
- ?>
- </table>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement