从特定的mysql表列中检索数据值并在php中打印

Question

I am trying to retrieve all values from the column country_name and table ban_country_ip and after print them:

<?php
 include("config.inc.php");
 $countryiso = mysql_query("SELECT distinct(country_name) as country_name FROM ban_country_ip");
while ($row = mysql_fetch_assoc($countryiso)) {
 echo $row['country_name'];
}

Answer 1

Distinct is not a function in mysql, use following query instead

"SELECT distinct country_name FROM ban_country_ip"