FileBack PC 4.1
Fast & Flexible Backup Software for Microsoft Windows
 • Home • Up • Product Info • Download • Buy Now! • Quotation • Support • Reference • Help • Forums • Contact MOS •

FileBack PC Knowledge Base

0)'; $ob = 'ACCESSCOUNT DESC'; } else if ($srch=='mu') { $wc = ''; $ob = '((helpfulyes)/(helpfulyes+helpfulno)) DESC'; } $sql = "SELECT * from articles WHERE (('".mysql_real_escape_string($prod)."'='') OR ('".mysql_real_escape_string($prod)."' LIKE product) OR (product=''))"; $sql .= " AND (('".mysql_real_escape_string($type)."'='') OR ('".mysql_real_escape_string($type)."' LIKE concat('%',enttype,'%')) OR (enttype=''))"; $sql .= " AND (('".mysql_real_escape_string($err)."'='') OR (errornum='$err') OR (errornum=0) OR (errornum IS NULL))"; if ($wc<>'') { $sql .= " AND $wc"; } if ($sterms<>'') { $sql .= " AND (MATCH(keywords,title,plaintext) AGAINST('".mysql_real_escape_string($sterms)."' IN BOOLEAN MODE) OR keywords like '%".mysql_real_escape_string($sterms)."%' "; $sql .= " OR title LIKE '%".mysql_real_escape_string($sterms)."%' OR plaintext like '%".mysql_real_escape_string($sterms)."%') "; if ($ob=='') { $ob = "MATCH(keywords,title,plaintext) AGAINST ('".mysql_real_escape_string($sterms)."') DESC"; } } $where = "p=$prod&t=$type&s=$srch&srch=$sterms&sum=$sum&pp=$numperpage"; if ($ob<>'') { $sql .= " ORDER BY $ob"; } else { $sql .= " ORDER BY enttype, accesscount desc"; } // print "SQL: $sql\n"; $lastent = null; $result = mysql_query($sql); if ($result) { $nr = mysql_num_rows($result); prevnext($start,$nr,$numperpage,$where); for ($j=0;$j<$nr;$j++) { $row=mysql_fetch_array($result); if (($j>=$start) && ($j<=$start+$numperpage-1)) { if (($lastent<>$row['enttype']) && ($ob=='')){ if ($j<>$start) print "
"; $lastent=$row['enttype']; } if ($sum!='1') { articleshortsummary($row); } else { articlesummary($row); } } } prevnext($start,$nr,$numperpage,$where); if ($sum!='1') { print "

Hover your mouse over a link to read a portion of its contents.

\n"; } } else { print "No matching articles were found."; } ?>

All Text, Images, and Scripts 1997-2009 Maximum Output Software.  All Rights Reserved.