$heretext = " ";
if(trim($hidcat)!="")
{
$strSQL = "SELECT * FROM dbdirectories_categorymaster WHERE categorycode = $hidcat ORDER BY categoryname";
$objRSPath = mysql_db_query($dbname,$strSQL);
echo mysql_error();
if ( mysql_num_rows($objRSPath) > 0 )
{
for ( $i = 0; $i < mysql_num_rows($objRSPath); $i++ )
{
$linkcatg = mysql_result($objRSPath,$i,"link_catg");
$arrlinkcat = explode("::",$linkcatg);
for ( $j = 0; $j < count($arrlinkcat); $j++ )
{
$strSQL1 = "SELECT * FROM dbdirectories_categorymaster WHERE categorycode = $arrlinkcat[$j]";
$objRSPath1 = mysql_db_query($dbname,$strSQL1);
echo mysql_error();
if ( mysql_num_rows($objRSPath1) > 0 )
{
if ( $j == (count($arrlinkcat) - 1) )
{
$heretext = $heretext."» ". mysql_result($objRSPath1,0,"categoryname")."";
}
else
{
$heretext = $heretext."» ". mysql_result($objRSPath1,0,"categoryname")." ";
}
}
}
}
}
}
?>
Welcome to Fuzion.com Directories
if(trim($hidcat)=="")
{
$dbquery = "select * from dbdirectories_categorymaster where parentcategory=0 AND (activestatus <> 'Inactive') order by categoryname";
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
}
else
{
$dbquery = "select * from dbdirectories_categorymaster where parentcategory='$hidcat' AND (activestatus <> 'Inactive') order by categoryname";
$result = mysql_db_query($dbname,$dbquery); if(mysql_error()!=""){echo mysql_error();}
}
while($row = mysql_fetch_array($result))
{
?>
$qry1 = "select * from dbdirectories_categorymaster where ((link_catg like '". $row["categorycode"] ."::%') or (link_catg like '%::". $row["categorycode"] ."::%'))";
$rslt = mysql_db_query($dbname,$qry1); if(mysql_error()!=""){echo mysql_error();}
if ( mysql_num_rows($rslt) > 0 )
{
?>
">
}
else
{
?>
&txt_searchstring=&txt_from=2">
}
?> |
if($row = mysql_fetch_array($result))
{
?>
$qry1 = "select * from dbdirectories_categorymaster where ((link_catg like '". $row["categorycode"] ."::%') or (link_catg like '%::". $row["categorycode"] ."::%'))";
$rslt = mysql_db_query($dbname,$qry1); if(mysql_error()!=""){echo mysql_error();}
if ( mysql_num_rows($rslt) > 0 )
{
?>
">
}
else
{
?>
&txt_searchstring=&txt_from=2">
}
?> |
}
?>
}
?>
|