Hey guys.
In my table i got strPlace, strCountry and some more, but thats not important.
And members can add places they been and then i want to loop the countries, but if someone added for example, 5 different places in one country, then I only want the country to show once, not 5 times.
What i got now is:
[php]$sql = mysql_query(“SELECT * FROM tblplace where strName = ‘$usr’”) or die(mysql_error());
while($list = mysql_fetch_array($sql))
{
echo $list[‘strCountry’];
}[/php]
Thanks.