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