ERROR: Unable to open database file!

';
print_r($col);
exit;
*/

$arrays = count($col) - 1;

$tablecells = '';
$loop = -1;
$and = $once = $found = $found1 = $found2 = $bothfound = $search2also = 'no';
$count = 0;
$speechmarks = '';

//test for AND4 but not four words that must be together (""):
if ((strstr($search,' AND4 ')) and ($search[0] <> '"')) {
  $and = 'yes';
//list last 2 $wordX's
  list ($word1, $word2, $word3, $word4, $word5, $word6, $word7) = explode (' ', $search); //remove AND
//add $wordX
  $word1 = strtolower($word1);
  $word3 = strtolower($word3);
  $word5 = strtolower($word5);
  $word7 = strtolower($word7);
  if ($word1 == $word3) {
    $search = $word1;
    $and = 'no';
  } else {
//add $wordX
      $search1 = $word1;
      $search2 = $word3;
      $search3 = $word5;
      $search4 = $word7;
      while ($loop < $arrays) {
      $loop++;
      $field = strtolower($col[$loop]);
//add search string
      if ((strstr($field,$search1)) and (strstr($field,$search2)) and (strstr($field,$search3)) and (strstr($field,$search4))) {
        $found = $found1 = $found2 = $found3 = $found4 = $bothfound = 'yes';
        //word1
        highlight($col[$loop],$field,$search1);
        $col[$loop] = $GLOBALS['result'];
        //word2
        $field = strtolower($col[$loop]); //update field to include highlighted version from above
        highlight($col[$loop],$field,$search2,$search3);
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




';
      $count++;
      }
    }
  }
}

//test for AND3 but not three words that must be together (""):
if ((strstr($search,' AND3 ')) and ($search[0] <> '"')) {
  $and = 'yes';
  list ($word1, $word2, $word3, $word4, $word5) = explode (' ', $search); //remove AND
  $word1 = strtolower($word1);
  $word3 = strtolower($word3);
  $word5 = strtolower($word5);
  if ($word1 == $word3) {
    $search = $word1;
    $and = 'no';
  } else {
      $search1 = $word1;
      $search2 = $word3;
      $search3 = $word5;
      while ($loop < $arrays) {
      $loop++;
      $field = strtolower($col[$loop]);
      if ((strstr($field,$search1)) and (strstr($field,$search2)) and (strstr($field,$search3))) {
        $found = $found1 = $found2 = $found3 = $bothfound = 'yes';
        //word1
        highlight($col[$loop],$field,$search1);
        $col[$loop] = $GLOBALS['result'];
        //word2
        $field = strtolower($col[$loop]); //update field to include highlighted version from above
        highlight($col[$loop],$field,$search2,$search3);
        //word3
        $field = strtolower($col[$loop]); //update field to include highlighted version from above
        highlight($col[$loop],$field,$search3);
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




';
      $count++;
      }
    }
  }
}


//test for AND but not two words that must be together (""):
if ((strstr($search,' AND ')) and ($search[0] <> '"')) {
  $and = 'yes';
  list ($word1, $word2, $word3) = explode (' ', $search); //remove AND
  $word1 = strtolower($word1);
  $word3 = strtolower($word3);
  if ($word1 == $word3) {
    $search = $word1;
    $and = 'no';
  } else {
      $search1 = $word1;
      $search2 = $word3;
      while ($loop < $arrays) {
      $loop++;
      $field = strtolower($col[$loop]);
      if ((strstr($field,$search1)) and (strstr($field,$search2))) {
        $found = $found1 = $found2 = $bothfound = 'yes';
        //word1
        highlight($col[$loop],$field,$search1);
        $col[$loop] = $GLOBALS['result'];
        //word2
        $field = strtolower($col[$loop]); //update field to include highlighted version from above
        highlight($col[$loop],$field,$search2);
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




';
      $count++;
      }
    }
  }
}




if (($and == 'no') and ($bothfound == 'no')) {

$search = strtolower($search);

$search1 = $search2 = '';
if (strstr($search,' ')) {
  list ($search1, $search2) = explode (' ', $search);
  if ($search2 == $search1) {//when both words are the same
    $search = $search1; //make search just first word
    $search1 = $search2 = ''; //destroy both words from split
  }
}

//test for space in search but not two words that must be together (""):
if ((strstr($search,' ')) and ($search[0] <> '"')) {
  list ($search1, $search2) = explode (' ', $search);
  //search for two separate words
  while ($loop < $arrays) {
    $loop++;
    $search2also = 'no';
		$field = strtolower($col[$loop]);
 		$fieldkept = $field; //preserve text without web code
		if (strstr($field,$search1)) {
      if (strstr($field,$search2)) {$search2also = $bothfound = 'yes';}
			$found = $found1 = 'yes';
      highlight($col[$loop],$field,$search1);
      $col[$loop] = $GLOBALS['result'];
      if ($search2also <> 'yes') { //only output once when both words on same row
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




';
        $count++;
      }
		}
    $field = strtolower($col[$loop]); //update field to include highlighted version from above
    if (strstr($fieldkept,$search2)) { //search on line without highlighting added
      $found = $found2 = 'yes';
      highlight($col[$loop],$field,$search2);
      if (($search2also == 'yes') or ($found2 == 'yes')) {
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




';
        $count++;
      }
		}
  }
} else {
  //check if speech marks and remove them:
  if ($search[0] == '"') {
    $search = str_replace('"','',$search);
    $speechmarks = '\''; //for output later
  }
  if ($search <> '') {
    //do normal search
    while ($loop < $arrays) {
      $loop++;
      $field = strtolower($col[$loop]);
      if (strstr($field,$search)) {
        $found = $found1 = 'yes';
        highlight($col[$loop],$field,$search);
        //add rows
        $col[$loop] = explode('|',$GLOBALS['result']);
        $tablecells.='




'.$col[$loop][3].'
'.$col[$loop][4].'
'.$col[$loop][5].'
'.$col[$loop][6].'
Keywords:
'.$col[$loop][11].'

View Front Image


Price: $'.$col[$loop][9].'
'.$col[$loop][14].' Available
(Subject To Any Prior Or Pending Sales)

Check out now




  ';
      $count++;
      }
    }
  } else {exit('No usable search string found!');}
}

} //if ($and == 'no')

//ORG
//echo '
Your search for \''.$speechmarks.$search.$speechmarks.'\' was found in the following '.$count.' lines of the database:
 (FROM TWO LINES DOWN)




//CHANGE

if ($found == 'yes') {
  echo 'Browsing table of '.$count.' '.$change2.' items

This table is sortable, just click on any heading. 







'.$tablecells.'







Code
Description
Condition
Notes

View

Buy


';
} else {
  echo '
Your search for \''.$speechmarks.$search.$speechmarks.'\' was not found.
';
}


echo '




 

 














';
echo date('F d Y H:i:s');


// Cache the output to a file
$fp = fopen($cachefile, 'w');
fwrite($fp, ob_get_contents());
fclose($fp);
ob_end_flush(); // Send the output to the browser
?>