olivebranchms/obms_r1/bsearchmain.php3

<?
function bsearch_main($category, $wordsearch, $contactsearch, $wordoption, $contactoption)
{
  $database_name = "olivebranch";
  $result = 0;

  $connection = pg_connect("localhost", "5432", $database_name);
  if($connection)
  {
    $multiple = 0;
    $query = "SELECT * FROM member WHERE ";

    if($category || $wordsearch || $contactsearch)
    {
      if($category)
      {
        $query .= "category = '" . $category . "'";

        $multiple = 1;
      }

      if($wordsearch)
      {
        if($multiple) $query .= " AND ";
  
        switch($wordoption)
        {
          case "start":
            $query .= "upper(company) LIKE upper('" . $wordsearch . "%')";
            break;
          case "contain":
            $query .= "upper(company) LIKE upper('%" . $wordsearch . "%')";
            break;
          case "end":
            $query .= "upper(company) LIKE upper('%" . $wordsearch . "')";
            break;
        }
  
        $multiple = 1;
      }
  
      if($contactsearch)
      {
        if($multiple) $query .= " AND ";
  
        switch($contactoption)
        {
          case "start":
            $query .= "upper(contact) LIKE upper('" . $contactsearch . "%')";
            break;
          case "contain":
            $query .= "upper(contact) LIKE upper('%" . $contactsearch . "%')";
            break;
          case "end":
            $query .= "upper(contact) LIKE upper('%" . $contactsearch . "')";
            break;
        }
      }
    }
    else $query .= "category is not null";

    $query .= " ORDER BY category,company,contact";

    $result = pg_exec($connection, $query);
    pg_close($connection);
  }

  return($result);
}
?>