Advertisement
Guest User

Untitled

a guest
Mar 17th, 2016
70
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.85 KB | None | 0 0
  1.  
  2. <html>
  3. <table style="width:100%">
  4. <tr>
  5. <th align="center">ID</th>
  6. <th align="center">Admin</th>
  7. </tr>
  8.  
  9. <?php
  10. error_reporting(0);
  11.  
  12. $dbhost = 'localhost';
  13. $dbuser = 'sourcebans';
  14. $dbpass = 'sourcebans';
  15. $dbdb = 'sourcebans';
  16. $conn = mysqli_connect($dbhost, $dbuser, $dbpass,$dbdb);
  17. if (mysqli_connect_errno())
  18. {
  19. echo "Failed to connect to MySQL: " . mysqli_connect_error();
  20. }
  21.  
  22.  
  23.  
  24.  
  25. $gatherall = mysqli_query($conn,"SELECT sb_comms.aid,sb_comms.user FROM sb_comms INNER JOIN sb_admins ON sb_comms.aid=sb_admins.aid GROUP BY aid ASC");
  26.  
  27. while ($res = mysqli_fetch_array($gatherall)):
  28. $aid = $res['aid'];
  29. //$bid = $res['bid'];
  30. $name = $res['user'];
  31. //$type = $res['type'];
  32.  
  33. ?>
  34.  
  35. <tr>
  36. <th><?php echo $aid;?></th>
  37. <th><?php echo $name;?></th>
  38. </tr>
  39.  
  40. <?php endwhile;?>
  41. </table>
  42.  
  43. </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement