Advertisement
Guest User

phpmm

a guest
Mar 29th, 2021
166
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.79 KB | None | 0 0
  1. <?php
  2.  
  3.  
  4. $servername = "localhost";
  5. $username = "root";
  6. $password = "**";
  7.  
  8. // Create connection
  9. $conn = new mysqli($servername, $username, $password);
  10.  
  11. // Check connection
  12. if ($conn->connect_error) {
  13. die("Connection failed: " . $conn->connect_error);
  14. }
  15. echo "Connected successfully";
  16.  
  17.  
  18.  
  19.  
  20.  
  21. $q = mysql_query("SELECT * FROM characters WHERE pvpkills > 0 AND accesslevel = 0 ORDER BY pvpkills DESC LIMIT 50");
  22. $i = 1;
  23. if ($q) {
  24. while ($char = mysql_fetch_array($q))
  25. {
  26. echo "<tr>";
  27. echo "<td style='width:11px;color:#000;'>" . $i . ".</td>";
  28. echo "<td style='width:20px;color:#000;'>" . $char['char_name'] . "</td>";
  29. echo "<td style='width:20px;text-align:right;padding-left:22px;color:#000;'>" . $char['pvpkills'] . "</td>";
  30. echo "</tr>";
  31. $i++;
  32. }
  33. }
  34. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement