$query = "select distinct city, country from addshow where status='Approved' and city LIKE 'H%' order by country, city";
$result = mysql_query($query);
while(list($city, $country)=mysql_fetch_array($result))
{
$array_city[$country][] = $city;
}
foreach($array_city as $key=>$value)
{
echo "
".$key."";
$x=1;
foreach($value as $key1=>$value1)
{
$linkvar = strtolower($value1);
$linkvar = str_replace(" ","-", $linkvar);
$linkvar = "../citywise/".$linkvar."/index.html";
if($x==count($value))
echo "
".$value1."";
else
echo "
".$value1.", ";
$x++;
}
echo "
";
}
?>