Advertisement
Guest User

Untitled

a guest
May 23rd, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.82 KB | None | 0 0
  1. <?php
  2. $host = "xxxxxxxxxx:xxxx"; // here is your Database address
  3. $mysql_user = "xxxxxxxxx"; // Database UserName
  4. $mysql_pass ="xxxxxxxx"; // Database Password
  5. $db = "character"; //Characters Database Name
  6.  
  7. @mysql_connect ("$host", "$mysql_user", "$mysql_pass") or die ("MySql Connection Error");
  8. @mysql_select_db ("$db") or die ("Database Connection Has Failed");
  9.  
  10. $query = mysql_query("SELECT name, online, level FROM `characters` WHERE `online`= 1 ORDER BY name") or die (mysql_error());
  11. $count=0;
  12.  
  13. print ( "<table align=center width=500 border=1 cellpadding=0 cellspacing=0><tr>" );
  14. while ($row_list = mysql_fetch_object($query))
  15. {
  16. print ( "<tr><td align=left style=\"padding: 0px 0px 0px 15px; background:#777;\"> ");
  17. echo $row_list->name." Level:".$row_list->level;
  18. print ("</td></tr> ");
  19. $count++;
  20. }
  21.  
  22.  
  23.  
  24. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement