require('../lib/hkweb.inc.php');
//if category has no corresponding records in CategoryLink table, the category
//will not be shown on the left side html's table.
function check_categorylink($category)
{
global $dbname,$id_link;
$sel_content = "select * from CategoryLink ";
$sel_content .= "where categorynum = $category ";
$contentresult = mysql_db_query($dbname,$sel_content,$id_link);
if(mysql_num_rows($contentresult))
{
return 1;
}
return 0;
}
$defaultflag = 0;
$sel_sql ="select * ";
$sel_sql .="from WebCategory ";
$sel_sql .="order by categorynum";
$result = mysql_db_query($dbname,$sel_sql,$id_link);
while ($record = mysql_fetch_object($result))
{
if ($defaultflag == 0)
{
$defaultcategorynum = $record->categorynum;
$defaultcategory = $record->category;
$defaultflag = 1;
}
if (check_categorylink($record->categorynum))
{
$alink="categorynum."')\">";
$alink.=" ";
$alink.="$record->category";
?>
|
|
}
unset($alink);
}
?>
|
|
$cellindex = 0;
$ncount = 1;
if (isset($action) && ($action == "postcategory"))
{
$sel_content = "select * from CategoryLink ";
$sel_content .= "where categorynum = $categorynum ";
$contentresult = mysql_db_query($dbname,$sel_content,$id_link);
$numoflink = mysql_num_rows($contentresult);
while ($contentrecord = mysql_fetch_object($contentresult))
{
$cellcolor = ($cellindex %2)? "#F5F5D3":"#FFFFFF";
$hyperlink = "websiteaddress\" ";
$hyperlink .="target=\"_blank\">";
$hyperlink .="$contentrecord->websitename";
if ($ncount == 1)
{
$sel_category ="select category ";
$sel_category .="from WebCategory ";
$sel_category .="where categorynum = $categorynum ";
$categoryresult = mysql_db_query($dbname,$sel_category,$id_link);
$categoryrecord = mysql_fetch_object($categoryresult);
?>
|
|
}//end if
?>
|
unset($hyperlink);
$cellindex++;
}//end of while
}
else
{
$sel_default_content = "select * ";
$sel_default_content .="from CategoryLink ";
$sel_default_content .="where categorynum = $defaultcategorynum ";
$defaultresult = mysql_db_query($dbname,$sel_default_content,$id_link);
$numoflink = mysql_num_rows($defaultresult);
while ($defaultcontent = mysql_fetch_object($defaultresult))
{
$cellcolor = ($cellindex %2)? "#F5F5D3":"#FFFFFF";
$hyperlink = "websiteaddress\" ";
$hyperlink .="target=\"_blank\">";
$hyperlink .="$defaultcontent->websitename";
if ($ncount == 1)
{
?>
|
|
}
?>
-
|
$cellindex++;
}//end of while
}//end if
?>
|
|