|
|
";
$i = 0;
if (mysql_num_rows($xresult)==0):
$query = "SELECT c.Country_ID, c.CountryName, CityName FROM country c, city ct where 1=1 and CountryName = '" . $Country . "' and ct.Country_ID = c.Country_ID";
$result = mysql_query($query) or die("Failed".mysql_error());
$CityName = $row -> CityName ;
if (mysql_num_rows($result)==0):
else:
while ($row = mysql_fetch_object($result)){
$htmlstr = $htmlstr . "| ";
$htmlstr = $htmlstr . "";
$htmlstr = $htmlstr . ucwords(str_replace("_", " ",$row -> CityName));
$htmlstr = $htmlstr . "";
$i = $i + 1;
if (fmod($i,3)==0):
$htmlstr = $htmlstr . " | ";
endif;
}
endif;
$htmlstr = $htmlstr . "
";
echo $htmlstr;
mysql_free_result($result);
else:
while ($row = mysql_fetch_object($xresult)){
$StateName = $row -> StateName ;
$htmlstr = $htmlstr . " | ";
$htmlstr = $htmlstr . "";
$htmlstr = $htmlstr . ucwords(str_replace("_", " ",$row -> StateName));
$htmlstr = $htmlstr . "";
$i = $i + 1;
if (fmod($i,3)==0):
$htmlstr = $htmlstr . " |
