header(); $terms = check_input($terms); $output .= "\n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= " \n"; $output .= "

\n"; $output .= "

\n"; ### Compose and perform query: $query = "SELECT s.id, s.subject, u.userid, s.timestamp, COUNT(c.cid) AS comments FROM stories s LEFT JOIN users u ON s.author = u.id LEFT JOIN comments c ON s.id = c.sid WHERE s.status = 2 "; $query .= ($author) ? "AND u.userid = '$author' " : ""; $query .= ($terms) ? "AND (s.subject LIKE '%$terms%' OR s.abstract LIKE '%$terms%' OR s.updates LIKE '%$terms%') " : ""; $query .= ($category) ? "AND s.category = '$category' GROUP BY s.id " : "GROUP BY s.id "; $query .= ($order == "Oldest first") ? "ORDER BY s.timestamp ASC" : "ORDER BY s.timestamp DESC"; $result = db_query("$query"); ### Display search results: $output .= "

\n"; while ($entry = db_fetch_object($result)) { $num++; $output .= "

$num) id\">$entry->subject (". format_plural($entry->comments, "comment", comments) .")
by ". format_username($entry->userid) .", posted on ". format_date($entry->timestamp) .".

\n"; } if ($num == 0) $output .= "

Your search did not match any articles in our database:

Try using fewer words.
Try using more general keywords.
Try using different keywords.

\n"; else $output .= "

$num results matched your search query.

\n"; $output .= "

\n"; $theme->box("Search", $output); $theme->footer(); ?>