|
:]]') ";
//if not last field give operator for next field
if ($f<(count($fieldSearch)-1)) {
$sql.=$like_sub_op;
}
}
$sql.=")";
if ($t<(count($terms)-1)) {
//if((($operators[$t]=="+")||($operators[$t]=="-"))&&(($operators[$t+1]!="+")&&($operators[$t+1]!="-"))||(($operators[$t+1]=="+")||($operators[$t+1]=="-"))&&(($operators[$t]!="+")&&($operators[$t]!="-"))){
if((($operators[$t]==("+"||"-"))&&($operators[$t+1]!=("+"&&"-")))||(($operators[$t+1]==("+"||"-"))&&($operators[$t]!=("+"&&"-")))){
$t++;
$skip="yes";
}
if(($operators[$t]=="+")||($operators[$t+1]=="+")||($operators[$t]=="-")||($operators[$t+1]=="-")){
$sql.=" AND ";
}else{
$sql.=" OR ";
}
}
}
// do date search
date_search($day, $month, $year);
// add order by and limit, then run the search
$like_sql=$sql." ORDER BY $order_field $order LIMIT $startRow_search, $maxRows_search";
$rsCat2_query=mysql_query($like_sql);
// return sql error
sql_err_zero($like_sql);
// if LIKE search retuns 0 results return 'no results' error
if (mysql_num_rows($rsCat2_query)==0) {
echo "| No items were found matching the criteria | ";
include("helpinc.php");
exit;
}
}
if (isset($rsCat2_query)){
$rsCat_query=$rsCat2_query;
$like_match="LIKE";
}else{
$like_match="Standard";
}
$query_total_search=mysql_query($sql);
$totalRows_search = mysql_num_rows($query_total_search);
$totalPages_search = ceil($totalRows_search/$maxRows_search)-1;
$page = $pageNum_search;
$total_pages = ceil($totalRows_search / $maxRows_search);
$display_links = 5;
?>
|