prepare("SELECT Name, Population FROM city WHERE Name LIKE :city ORDER BY Name");
$stmt->bindValue(":city", "$city%", PDO::PARAM_STR);
$stmt->execute();
$result = $stmt->fetchAll(PDO::FETCH_ASSOC);
foreach( $result as $row ){
echo "City: ".$row['Name'];
echo " Population: ".$row['Population'];
echo "
";
}
?>