[Solved] how can foreach mysql result?

by


Try PDO. It’s a much better and safer way of interacting with databases for PHP. http://php.net/manual/en/pdo.connections.php

$dbh = new PDO("mysql:host=$host;dbname=$dbname", $user, $pass);
$hetimostfin = array();
$coppers = 3000;
$line = 0;

$query = <<<SQL
SELECT 
   playerID, 
   COUNT(valami2) AS `count`
FROM players_extra
GROUP BY playerID;
SQL;

foreach($dbh->query($query, PDO::FETCH_ASSOC) as $row) {
    $hetimostfin[[$row['playerID']] = $row['count'];
    // execute update statement
    $line++;
}

solved how can foreach mysql result?