PHP Дважды выводит данные из mysql, в чём проблема?

Question

[winslowsCO]

немогу никак разобратся, где ошибка?
$sql = 'SELECT serviceType, price FROM services';
$result = $pdo->query($sql);

while($row = $result->fetch()) {
foreach($row as $key => $value) {
echo "" . htmlspecialchars($value, ENT_QUOTES, 'UTF-8'). "";
}
}

Answer 1

[Макс]

$sql = 'SELECT serviceType, price FROM services';

$result = $pdo->query($sql);

while($row = $result->fetch(PDO::FETCH_ASSOC)) {
    foreach($row as $key => $value) {
        echo "" . htmlspecialchars($value, ENT_QUOTES, 'UTF-8'). "";
    }
}

По умолчанию обычно FETCH_BOTH

Answer 2

[stpnov]

while($row = $result->fetch()) {

не пойму зачем, думаю так правильней

$sql = 'SELECT serviceType, price FROM services';
$result = $pdo->query($sql);

foreach($row = $result->fetchAll() as $key => $value) {
echo "" . htmlspecialchars($value, ENT_QUOTES, 'UTF-8'). "";
}

Answer 3

[Максим Максим]

$sql = 'SELECT serviceType, price FROM services';
$result = $pdo->query($sql);

foreach($row as $key => $value) {
echo "" . htmlspecialchars($value, ENT_QUOTES, 'UTF-8'). "";
}