' . mysql_error()); while ($line = mysql_fetch_array($result)) { header("Location:offshore.multiple.php?country=" . urlencode(stripslashes($line[overview]))); exit; } } // # make sure there's at least one published jurisdiction $stmt= "SELECT * FROM $news_table[0] WHERE PUBLISHED='yes' AND CATEGORY LIKE '$category - $juris%' AND overview!='' GROUP BY overview ORDER BY DATE DESC " ; //echo $stmt; if (!$result=mysql_query($stmt)) die($stmt . '

' . mysql_error()); $num = mysql_num_rows($result); //echo '

' . $num; if ($num==0) unset($juris); if (!isset($juris)) { header("Location:offshore.php"); exit; } $page->renderHead(); ?>

\n"; echo "\n"; $res = $result; while ($line=jss(mysql_fetch_array($res, MYSQL_ASSOC))) { $i++; if ($i==1) { echo "\n"; echo "\t\n"; } echo "\t\t\n"; if ($i==$numPerRow) { echo "\t\n"; echo "\n"; $i=0; } } if ($i>0) { while ($i<=$numPerRow) { $i++; echo "\t\t\n" ; if ($i>=$numPerRow) { echo "\t\n"; echo "\n"; break; } } } echo "
\n"; unset($pInf); unset($mInf); $pInf = jfi($news_table[0],'ID',$line[ID]); $stmt= "SELECT * FROM $news_table[0] WHERE overview='" . addslashes($pInf[overview]) . "' AND PUBLISHED='yes' " ; $res2 = jmq($stmt, __LINE__, __FILE__); $num = mysql_num_rows($res2); if ($num>1) { $thisLink = 'offshore.multiple.php?country=' . urlencode($pInf[overview]); } else { $thisLink = "item.php?id=$pInf[ID]" ; } $mInf = jfi($img_table[0],'passkey',$line[passkey]); if ($mInf[ID]!='') { $imgLink = "img.php?id=$mInf[ID]"; } else { $imgLink = "images/flag.na.gif"; $mInf[WIDTH]=95; $mInf[HEIGHT]=60; } echo "\t\t\t" ; echo ""; echo "
\n"; echo "\t\t\t$pInf[overview]

\n"; echo "\t\t
 
\n"; echo "\n\n\n"; // # get live offshore categories $stmt= "SELECT * FROM $news_table[0] WHERE PUBLISHED='yes' AND ( CATEGORY LIKE '$category%' OR CATEGORY2 LIKE '$category%' ) AND CATEGORY !='$category' AND CATEGORY !='$category - FAQ' AND CATEGORY !='$category - General' AND CATEGORY !='$category - Order Form' AND CATEGORY !='$category - Banking' AND CATEGORY !='$category - Banking and Anonymous Banking' AND CATEGORY !='$category - Trusts' AND CATEGORY !='$category - Foundations' AND CATEGORY !='$category - Companies' GROUP BY CATEGORY ORDER BY CATEGORY " ; if (!$result=mysql_query($stmt)) die($stmt . '

' . mysql_error()); $dispSubCat = array(); while ($line=mysql_fetch_array($result)) { if (ereg(' - ' , $line[CATEGORY])) { $catArr = explode(' - ', $line[CATEGORY]); $line[CATEGORY] = $catArr[1]; } $line[CATEGORY] = stripslashes($line[CATEGORY]); $tmpCat = explode(', Special Offer', $line[CATEGORY]); $line[CATEGORY] = $tmpCat[0]; $showIt = true; while (list($key,$val) = each($dispSubCat)) { if ($line[CATEGORY]==$val) { $showIt=false; break; } } reset($dispSubCat); if ($showIt) { $dispSubCat[] = $line[CATEGORY]; } } ?>
"> Explore Other Jurisdictions:
renderFoot(); ?>