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.";
}
?> |
