|
|
"; $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 . ""; 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 . " |
