<?php
  require_once 'conn.php';
  require_once 'outputfunctions.php';
  require_once 'header.php';
  
  $result\; =\; NULL;\; if\; (isset($_GET['keywords'])) {
    $sql\; =\; "SELECT\; article\_id\; FROM\; cms\_articles\; "\; .\; "WHERE\; MATCH\; (title,body)\; "\; .\; "AGAINST\; (\text{'}"\; .$_GET['keywords'] . "' IN BOOLEAN MODE) " .
           "ORDER BY MATCH (title,body) " .
           "AGAINST ('" . $\_GET[\text{'}keywords\text{'}]\; .\; "\text{'}\; IN\; BOOLEAN\; MODE)\; DESC";$result = mysql_query($sql,$conn)
      or die('Could not perform search; ' . mysql_error());
  }
  
  echo "<h1>Search Results</h1>\n";
  
  if ($result\; and\; !mysql\_num\_rows($result)) {
    echo "<p>No articles found that match the search terms.</p>\n";
  } else {
    while ($row\; =\; mysql\_fetch\_array($result)) {
      outputStory($row[\text{'}article\_id\text{'}],\; TRUE);\; \}\; \}\; require\_once\; \text{'}footer.php\text{'};\; ?>$