$embeddedContent = true;
require_once 'include/page.setup.inc.php';
$title = 'Offshore Incorporations: ' . $_GET[juris];
$category = 'Offshore Incorporations';
$subNavArr['home.php'] = 'Home';
$subNavArr['offshore.php'] = 'Offshore Incorporations';
$subNavArr['NOLINK'] = $_GET[juris];
$page = new renderPage($title, $content, $subNavArr, '', '', '');
$subCat = $juris;
$juris = addslashes($juris);
if ($juris=='US Corporations and LLCs')
{
$stmt= "SELECT * FROM $news_table[0]
WHERE PUBLISHED='yes'
AND CATEGORY LIKE '%$juris%'
AND overview != ''
LIMIT 0,1
" ;
if (!$result=mysql_query($stmt)) die($stmt . '
' . 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";
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 " \n"; echo "\t\t\t$pInf[overview] \n"; echo "\t\t | \n";
if ($i==$numPerRow)
{
echo "\t\n" ; if ($i>=$numPerRow) { echo "\t\n"; echo "\n"; break; } } } echo " |