<?php
error_reporting(E_ALL);

$servername = "localhost";
$username = "root";
$password = "";
$dbname = "steam";

$db = new mysqli($servername, $username, $password, $dbname);

if ($db->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}

$acc = "SELECT * FROM accounts WHERE public = '1' AND idle > 0 AND XD = 0 ORDER BY id limit 1";

if ($result = $db->query($acc)) {
    while ($row = $result->fetch_assoc()) {
	   $login = $row['login'];
	   $db->query("UPDATE accounts SET XD = 2 where `login` = '$login'");
       echo $row['login'].'<br />';
       echo $row['password'].'<br />';
    }
}
?>