Guest User

Untitled

a guest
Oct 26th, 2017
115
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.59 KB | None | 0 0
  1. $mysql_user = "root";
  2. $mysql_pass = "****";
  3. $mysql_host = "****";
  4. $mysql_dbl = "log";
  5. $db = new mysqli($mysql_host, $mysql_user, $mysql_pass);
  6. $db->select_db($mysql_dbl);
  7. $sql = "SELECT * FROM player";
  8. $result = $db->query($sql);
  9. while($daten = $result->fetch_array()){
  10. $sql = "SELECT * FROM log WHERE who = '$daten[id]'";
  11. $result2 = $db->query($sql);
  12. while($daten2 = $result2->fetch_array()){
  13. echo "Zeit: $daten2[time] | Account-Id: $daten2[who] | Playername: $daten[name]";
  14. }
  15. }
  16.  
  17. $db->close();
Add Comment
Please, Sign In to add comment