Total Search result found ",$trow,"

"; if($page==NULL) $page=0; else $page=$page-1; $start=($page*20)+1; $end=($page+1)*20; $query="select * from (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.state=$state order by directory.id desc limit $start,$end ) as table1"; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "
"; $count=$count+1; if($count%2==0) $bg="#f5f5f5"; else $bg="#e5e5e5" ?> <? echo $row[1];?>

",$row1[1]," | "; } ?>
...


Refine Search Result By District
",$row[1],"   "; } ?>

GOTO Page : ",$i," ";; } ?> Total Search result found ",$trow,"

"; if($page==NULL) $page=0; else $page=$page-1; $start=($page*20)+1; $end=($page+1)*20; $query="select * from (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.state=$state and directory.district=$district order by directory.id desc limit $start,$end ) as table1"; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "
"; $count=$count+1; if($count%2==0) $bg="#f5f5f5"; else $bg="#e5e5e5" ?> <? echo $row[1];?>

",$row1[1]," | "; } ?>
...



Refine Search Result By Directory Category
",$row[1],"   "; } ?>

Refine Search Result By District
",$row[1],"   "; } ?>

GOTO Page : ",$i," ";; } ?> ",$_GET["message"],"
Total Search result found ",$trow,"
"; if($page==NULL) $page=0; else $page=$page-1; $start=($page*20)+1; $end=($page+1)*20; //echo ""; $query="select * from (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.state=$state and directory.district=$district and directory.directorytype=$category order by directory.id desc limit $start,$end ) as table1"; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "
"; $count=$count+1; if($count%2==0) $bg="#f5f5f5"; else $bg="#e5e5e5" ?> <? echo $row[1];?>

",$row1[1]," | "; } ?>
...



Refine Search Result By Directory Category
",$row[1],"   "; } ?>

Refine Search Result By District
",$row[1],"   "; } ?>

GOTO Page : ",$i," ";; } ?>

Search result for "; $l=$l." content like '%".$q."%' or "; $pieces = explode(" ", $q); $ln=str_word_count($q); for($i=0;$i<$ln;$i++) { $l=$l." content like '% ".$pieces[$i]." %' or "; echo "#",$pieces[$i]," "; } echo "
"; $l=$l." content like '%%'" ; if($loc!=NULL) $l=$l." and content like '% ".$loc." %'"; $l=$l. " order by rand() limit 0,50"; //echo $l; //echo "
"; $query="select * from (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.state=$state and directory.district=$district and directory.directorytype=$category order by directory.id desc limit 0,30 ) as table1 where $l"; //echo $query; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "
"; $count=$count+1; if($count%2==0) $bg="#f5f5f5"; else $bg="#e5e5e5" ?> <? echo $row[1];?>

",$row1[1]," | "; } ?>
...

  • ",$row[1]," in ",$row[2]," (",$row[3],") - \n"; } ?>
  • Search result for "; $l=$l." content like '%".$q."%' or "; $pieces = explode(" ", $q); $ln=str_word_count($q); for($i=0;$i<$ln;$i++) { $l=$l." content like '% ".$pieces[$i]." %' or "; echo "#",$pieces[$i]," "; } echo ""; $l=$l." content like '%hhhjftyfty%'" ; //if($loc!=NULL) //$l=$l."content like '% ".$loc." %'"; $l=$l. " order by rand() limit 0,50"; //echo $l; //echo "
    "; $query="select * from (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 limit 0,30 ) as table1 where $l"; //echo $query; $result=mysql_query($query); while ($row = mysql_fetch_array($result)) { echo "
    "; $count=$count+1; if($count%2==0) $bg="#f5f5f5"; else $bg="#e5e5e5" ?> <? echo $row[1];?>

    ",$row1[1]," | "; } ?>
    ...