Companies/Directories Search

Looking For
Choose Directory Category	All Categories 0) { while($rowcategory = mysql_fetch_array($resultcategory)) { $aid = ""; $heretext1 = ""; $strSQLA = "SELECT * FROM dbdirectories_categorymaster WHERE categorycode = $rowcategory[categorycode] order by parentcategory,categoryname"; $objRSPathA = mysql_db_query($dbname,$strSQLA); $TotalRecord_Interior=mysql_num_rows($objRSPathA); if(mysql_error()!=""){echo mysql_error();} if ( mysql_num_rows($objRSPathA) > 0 ) { for ( $i = 0; $i < mysql_num_rows($objRSPathA); $i++ ) { $linkcatg = mysql_result($objRSPathA,$i,"link_catg"); $arrlinkcat = explode("::",$linkcatg); for ( $j = 0; $j < count($arrlinkcat); $j++ ) { $strSQLB = "SELECT * FROM dbdirectories_categorymaster WHERE categorycode = $arrlinkcat[$j]"; $objRSPathB = mysql_db_query($dbname,$strSQLB); if(mysql_error()!=""){echo mysql_error();} if ( mysql_num_rows($objRSPathB) > 0 ) { $strSQLB_checkroot = "SELECT * FROM dbdirectories_categorymaster WHERE ((link_catg like '".$rowcategory[categorycode]."::%') or (link_catg like '%::".$rowcategory[categorycode]."::%'))"; $objRSPathB_checkroot = mysql_db_query($dbname,$strSQLB_checkroot); if(mysql_error()!=""){echo mysql_error();} if ( mysql_num_rows($objRSPathB_checkroot)==0 ) { $r = mysql_fetch_array($objRSPathB); $aid = $r[autoid]; if ( $r[categorycode] == $row[categorycode] ) { $heretext1 = $heretext1 ."» ". mysql_result($objRSPathB,0,"categoryname")." "; if($founded != "Yes") { $found_check = "true"; $founded = "Yes"; } } else { $heretext1 = $heretext1 ."» ". mysql_result($objRSPathB,0,"categoryname")." "; } } } } if ( $heretext1 != "" ) { ?> >
Choose Country	All Countries >
State	All States >  If Other " maxlength=99 size=10>
Zip Code	" maxlength=99 size=15>