/*CREATE database test123 CHARACTER SET utf8 COLLATE utf8_general_ci;
USE test123;
CREATE TABLE test(
    id INT UNSIGNED AUTO_INCREMENT,
    name VARCHAR (50),
    mark INT UNSIGNED,
    PRIMARY KEY(id)
);
INSERT INTO test (name, mark) VALUES ('Иннокентий', 120), ('Афанасий', 190), ('Геннадий', 140);*/

<?php
header('Content-type: text/html;charset=utf8');
$pdo = new PDO('mysql:host=localhost;dbname=test123','root','');
$pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$pdo->query("SET NAMES utf8");
$sql = "SELECT id, name, mark FROM test ORDER BY :order LIMIT 0, 100";
$stmt = $pdo->prepare($sql);
$order = 'name';
$stmt->bindValue(':order', $order, PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll();

echo '<table>';
foreach($result as $row){
    echo '<tr>';
    echo "<td>{$row['id']}</td>";
    echo "<td>{$row['name']}</td>";
    echo "<td>{$row['mark']}</td>";
    echo '</tr>';
}
echo '</table>';