Guest User

Untitled

a guest
Jun 8th, 2018
97
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.77 KB | None | 0 0
  1. <?php
  2. $user = 'root';
  3. $password = '';
  4. $db = 'tfs';
  5. $sqlconnect = mysql_connect('localhost', $user, $password);
  6. $dbselect = mysql_select_db($db);
  7. $query = mysql_query ("SELECT rebirths, name FROM `players` WHERE name != Account Manager ORDER BY rebirths DESC");
  8. $x = 1;
  9. if (!$sqlconnect) {
  10.     die("error" . mysql_error());
  11. }
  12. if(isset($SQL)){
  13. $main_content .= "<table style='font-size: 110%;font-weight: bold;'><b><u>Rebirth Highscores: </b></table>";
  14. while ($row = mysql_fetch_array($query)) {
  15.     $main_content .= "<br />";
  16.     $main_content .='#' . $x;
  17.     $x++;
  18.     $main_content .=' ' . $row['name'];
  19.     $main_content .="<br />";
  20.     $main_content .="Rebirths:";
  21.     $main_content .=$row['rebirths'];
  22.     $main_content .="<br />";
  23. }
  24. }
  25. else {
  26.     die("error: not connected to db");
  27.     }
  28.  
  29. ?>
Add Comment
Please, Sign In to add comment