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 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']);
	//$col[$loop][66] = substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));		
//$col[$loop][66] = substr($col[$loop][7], 0, (stripos($col[$loop][7], "=")+1));
	//$col[$loop][89] = trim($col[$col[$loop][66]], "'");

		//substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));
	//$col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");


$findme   = '=';
$pos = strpos($col[$loop][7], $findme);

// Note our use of ===.  Simply == would not work as expected
// because the position of 'a' was the 0th (first) character.
if ($pos === false) {
    $col[$loop][66] = trim($col[$loop][7], "'");
} else {
    $col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");
}

	//$col[$loop][66] = trim($col[$loop][7], "'");
        $tablecells.='




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


CLICK_HERE To_View Full_Size_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']);
	//$col[$loop][66] = substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));		
//$col[$loop][66] = substr($col[$loop][7], 0, (stripos($col[$loop][7], "=")+1));
	//$col[$loop][89] = trim($col[$col[$loop][66]], "'");

		//substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));
	//$col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");


$findme   = '=';
$pos = strpos($col[$loop][7], $findme);

// Note our use of ===.  Simply == would not work as expected
// because the position of 'a' was the 0th (first) character.
if ($pos === false) {
    $col[$loop][66] = trim($col[$loop][7], "'");
} else {
    $col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");
}

	//$col[$loop][66] = trim($col[$loop][7], "'");
        $tablecells.='




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


CLICK_HERE To_View Full_Size_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']);
	//$col[$loop][66] = substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));		
//$col[$loop][66] = substr($col[$loop][7], 0, (stripos($col[$loop][7], "=")+1));
	//$col[$loop][89] = trim($col[$col[$loop][66]], "'");

		//substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('='));
	//$col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");


$findme   = '=';
$pos = strpos($col[$loop][7], $findme);

// Note our use of ===.  Simply == would not work as expected
// because the position of 'a' was the 0th (first) character.
if ($pos === false) {
    $col[$loop][66] = trim($col[$loop][7], "'");
} else {
    $col[$loop][66] = trim(substr($col[$loop][7], strripos($col[$loop][7],'=')+strlen('=')), "'");
}

	//$col[$loop][66] = trim($col[$loop][7], "'");
        $tablecells.='




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


CLICK_HERE To_View Full_Size_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 '


 




';
include("/home/seocom5/public_html/postcard/footersales.html"); 

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
?>