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 Full Size Image


Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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 Full Size Image


Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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 Full Size Image

Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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 Full Size Image


Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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 Full Size Image

Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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 Full Size Image


Price: $'.$col[$loop][9].'
Quantity:

 1
 2
 3
 4
 5


 6
 7
 8
 9
 10



   20
   25
   30
   35
   40
   45
   50




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.' '.$change.'



"Twofer Special" - Buy Two Different Individual Remebrance Postcards Listed Below, Get Another Different One Free!!! (No Duplication Of Cards Allowed)
(All price adjustments will be made on your FINAL invoice that will be sent to you after purchase.)




 







'.$tablecells.'







Code
Description
Condition
Notes

View

Buy


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


echo '

For further information on any items, please Contact Me

Please include Code Number, 

Description, and Price in all correspondence.



















';
?>