0){
$tmp = "A:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'b%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "B:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'c%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "C:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'd%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "D:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'e%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "E:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'f%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "F:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'g%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "G:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'h%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "H:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'i%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "I:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'j%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "J:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'k%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "K:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'l%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "L:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'm%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "M:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'n%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "N:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'o%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "O:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'p%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "P:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'q%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "Q:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'r%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "R:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 's%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "S:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'T%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "T:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'u%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "U:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'v%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "V:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'w%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "W:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'x%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "X:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'y%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "Y:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$q = "select count_id,country from countries where country like 'z%'";
$rs = mysql_query($q,$con);
if(mysql_num_rows($rs)>0){
$tmp = "Z:";
while($obj = mysql_fetch_object($rs)){
$tmp .="country)."-".$ft . $uri.encode($obj->country).".html\" class=\"link_countries s1\">".$obj->country.":";
}
//while
$col1 .= $tmp;
}//if
$arr = split(":",$col1);
$col1 = "";
for($i=0; $i<=count($arr);$i++)
{
if($i<=58){
$col1 .= $arr[$i] . "
";
}else if($i<=117){
$col2 .= $arr[$i]. "
";
}else if($i<=175){
$col3 .= $arr[$i]. "
";
}else{
$col4 .= $arr[$i]. "
";
}
}
include "class.FastTemplate.php3";
$tpl = new FastTemplate("./templates");
$tpl->define(array(
countries=>"countries.tpl",
footer=>"footer.tpl",
nav=>"nav.tpl"
));
$bread;
$tpl->assign("META1",$meta1);
$tpl->assign("META2",$meta2);
$tpl->assign("TITLE",$title);
$tpl->assign("SEARCHFOR",$searchfor);
$tpl->assign("COL1",$col1);
$tpl->assign("COL2",$col2);
$tpl->assign("COL3",$col3);
$tpl->assign("COL4",$col4);
$tpl->assign("BREAD",$bread);
$tpl->parse("FOOTER","footer");
$tpl->parse("NAV","nav");
$tpl->parse(MAIN,"countries");
$tpl->FastPrint();
?>