Search result for

Total Result found : ",$row[0],"


"; $totalresult=$row[0]; } $sql="select directory.id,directory.orgname,directory.website,concat(state.state,' » ',district.district,' : ', directory.orgname,' ',directory.orgaddress,' ', directory.pin,' ',directory.email,' ',directory.phone,' ',directory.mobile,' ',directory.fax,' ',directory.website, ' ',directory_type.directorytype) AS content from district,state,directory,directory_type where state.stateid=district.stateid and district.districtid=directory.district and state.stateid=directory.state and directory_type.dirid=directory.directorytype and directory.status=1 and directory.district=$district and directory.state=$state and status=1 limit $start,$end"; } else if($district!=NULL) { $q="select count(*) from directory where district=$district and status=1"; //echo $q; $r=mysql_query($q); while ($row = mysql_fetch_array($r)) { echo "
Total Result found : ",$row[0],"


"; $totalresult=$row[0]; } $sql="select * from directory where district=$district and status=1 limit $start,$end"; } else if($state!=NULL) { $q="select count(*) from directory where state=$state and status=1"; //echo $q; $r=mysql_query($q); while ($row = mysql_fetch_array($r)) { echo "
Total Result found : ",$row[0],"


"; $totalresult=$row[0]; } $sql="select * from directory where state=$state and status=1 limit $start,$end"; } else if($dirtype!=NULL) { $q="select count(*) from directory where directorytype=$dirtype and status=1"; //echo $q; $r=mysql_query($q); while ($row = mysql_fetch_array($r)) { echo "
Total Result found : ",$row[0],"


"; $totalresult=$row[0]; } $sql="select directory.id,directory.orgname,directory.website,concat(state.state,' » ',district.district,' : ', directory.orgname,' ',directory.orgaddress,' ', directory.pin,' ',directory.email,' ',directory.phone,' ',directory.mobile,' ',directory.fax,' ',directory.website, ' ',directory_type.directorytype) AS content from district,state,directory,directory_type where state.stateid=district.stateid and district.districtid=directory.district and state.stateid=directory.state and directory_type.dirid=directory.directorytype and directory.status=1 and directory.directorytype=$dirtype order by directory.id desc limit $start,$end"; } else { $sq2="select directory.directorytype,directory_type.directorytype,count(*) as n from directory, directory_type where directory.directorytype=directory_type.dirid and directory.status=1 group by directory.directorytype,directory_type.directorytype order by n desc"; $result=mysql_query($sq2); $c=0; while ($row = mysql_fetch_array($result)) { $c=$c+1; echo "
  • ",$row[1]," in India \n"; ?>
  • "; while ($row = mysql_fetch_array($result)) { $count=$count+1; if($count%2==0) $bg="#ffffff"; else $bg="#fffeee" ?> <? echo $row[1];?> <? echo $row[1];?>
    ",$row1[1]," | "; } ?>
    ...
    "; ?>

    ",$i," "; if($dirtype!=NULL) echo "",$i," "; } ?>