CREATE TABLE City (
Name VARCHAR(64),
District VARCHAR(64)
);
INSERT INTO City VALUES
('Aachen', 'Nordrhein-Westfalen'),
('Augsburg', 'Baijeri'),
('Bergisch Gladbach', 'Nordrhein-Westfalen'),
('Berlin', 'Berliini'),
('Bielefeld', 'Nordrhein-Westfalen');
<?php
$query = 'SELECT Name FROM City WHERE District=? ORDER BY Name LIMIT 5';
$result = $mysqli->execute_query($query, ['Nordrhein-Westfalen']);
if ($result->num_rows > 0) {
foreach ($result as $row) {
printf("%s \n", $row["Name"]);
}
} else {
echo 'Data not found';
}