Main Categories
| | | | | |
GetAllRows($strSQL, &$ascSubCatResult, &$blnMoreRows, SQL_GET_ROW_COUNT, &$sclSubCatID, "Select parent Category data");
//print $strSQL;
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__);
include "bottom.phtml";
exit;
}
$intSubCatRows = $g_objDB->GetRowCount($sclSubCatID);
$intX = 0;
if(($intSubCatRows == 0) && ($g_intCatID != "") && $g_intCatID)
{
?>There are no subcategories in this Category. |
FreeResults($sclSubCatID);
$strSQL = "SELECT CategoryName FROM tblCategory WHERE CatID = ".$ascSubCatResult[$intX]['ParentID'];
$sclNameResultID = $g_objDB->GetFirstRowOfSet($strSQL, &$ascCatNameResult, SQL_GET_ROW_COUNT, "Get Category Name");
if($g_objDB->HasError())
{
$g_objDB->DisplayError(__FILE__, __LINE__);
include "bottom.phtml";
exit;
}
elseif(!$g_objDB->GetRowCount($sclNameResultID))
{
$g_objDB->DisplayError("", 0, "Category Name Not Found.");
include "bottom.phtml";
exit;
}
$g_objDB->FreeResults($sclNameResultID);
?>Sub-Categories in Category
|