0){$st=$st-($previous*$listnos);$previous=0;} if($next>0){$st=$st+($next*$listnos);$next=0;} if($st<0){$st=0;} #making sql query **** begin $sql=" from classifieds where expiry>=now() "; //search criteria starts here $criteria=""; $stype="all"; if(!empty($sword)) { //entire phrase search if(!in_array($sword,$blockwords)) //avoid blocked words { $criteria.=" or matter like '%".$sword."%'"; $criteria.=" or keywords like '%".$sword."%'"; array_push($sw,$sword); } if($stype=="any" || $stype=="all") { #search type logic connector if($stype=="all"){$sconnect="and";$criteria.=" or (1";}else{$sconnect="or";$criteria.=" or (1=2";} //criteria for multi word search $swords=split(" ",$sword); $newsword=""; if(count($swords)>1) { for($i=0;$i
2) //avoid sword with <=2 characters { $newsword.=$swords[$i]." "; if(!in_array($swords[$i],$blockwords)) //avoid blocked words { array_push($sw,$swords[$i]); $criteria.=" $sconnect ("; //use logic connector //sword replacing nonreadable chars with any char $swordt=ereg_replace("[^a-zA-Z0-9]",".{0,3}",$swords[$i]); if($swordt!=".{0,3}") { $criteria.=" matter regexp '.*".$swordt.".*'"; $criteria.=" or keywords regexp '.*".$swordt.".*'"; } $criteria.=")"; //use logic connector } } } } if(empty($newsword)){$criteria.="=2";} //if empty criteria for multi words $criteria.=") "; //use logic connector $newsword=trim($newsword); if(!empty($newsword)){$sword=$newsword;} } $sql.=$criteria; } //if a category is selected if(!empty($catid)) { $sql.=" and catid like '".$catid."%' "; } $sql.="order by $orderby $sortorder"; //echo $sql; $entries=mysqli_query($db,"select count(*) as cnt ".$sql); $entryrec=mysqli_fetch_object($entries); $totcnt=$entryrec->cnt; $sql.=" limit ".$st.",".($listnos+1); $entries=mysqli_query($db,"select *".$sql); $cnt=mysqli_num_rows($entries); if($cnt>$listnos){$next=1;$cnt=$listnos;} if($st>0){$previous=1;} $color=""; if($cnt>0) { ?> catid; ?>
cid."' class='adminedit'>EDIT
"; ?> {"photo$j"}=="Y") { echo "
cid."&prefix=$j\" target=\"_blank\">
cid."&prefix=$j"."_thumb\" border=\"0\">
"; $photocnt++; } } if($photocnt>0) echo "
"; ?>